Results of 1 - 9 of about 9 for twice (0.003 sec.)
- Autocomplete 12259
- The shell offers context-aware autocomplete of SQL queries through the autocomplete extension . autocomplete is triggered by pressing Tab . Multiple autocomplete suggestions can be present. You can cycle forwards through the suggestions by
...repeatedly pressing Tab , or Shift+Tab to cycle backwards. autocompletion can be reverted by pressing ESC twice. The shell autocompletes four different groups: Keywords Table names and table functions Column names and scalar functions... - https://man.mtool.work/duckdb/2.0/clients/cli/autocomplete.html
- HAVING Clause 12259
- The HAVING clause can be used after the GROUP BY clause to provide filter criteria after the grouping has been completed. In terms of syntax the HAVING clause is identical to the WHERE clause, but while the WHERE clause occurs before the gr
...nt(*) >= 50; Compute the average income per city per street_name , filtering out cities with an average income bigger than twice the median income : SELECT city, street_name, avg(income) FROM addresses GROUP BY city, street_name HAVING avg(income) > 2... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/having.html
- Securing Extensions 9059
- DuckDB has a powerful extension mechanism, which has the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options listed on this page
...cripts from the web into our shells, and routinely install a staggering amount of transitive dependencies without thinking twice. Some repositories like CRAN enforce a human inspection at some point, but that's no guarantee for anything either. We've... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- MySQL Extension 8268
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...SQL query to execute. The result of the query is returned. Single-quote strings are escaped by repeating the single quote twice. mysql_query(attached_database::VARCHAR, query::VARCHAR) For example: ATTACH 'host=localhost database=mysql' AS mysqldb (T... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Relational API 7873
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...ference is EXCEPT ALL , so duplicates count: a row that appears three times in this relation and once in other_rel appears twice in the result. Parameters other_rel : DuckDBPyRelation The relation to combine with this one; it must have the same number...in other_rel. The intersection is INTERSECT ALL , so duplicates count: a row that appears three times in this relation and twice in other_rel appears twice in the result. Parameters other_rel : DuckDBPyRelation The relation to combine with this one; i... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Delta Extension 7873
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
...ogs: ATTACH '⟨path⟩' AS my_table (TYPE delta); CHECKPOINT my_table; Idempotent Appends To retry a batch without writing it twice, tag the append with an application ID and a version. DuckDB commits the append only if the table's last recorded version... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- PostgreSQL Extension 7873
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...SQL query to execute. The result of the query is returned. Single-quote strings are escaped by repeating the single quote twice. postgres_query(attached_database::VARCHAR, query::VARCHAR) For example: ATTACH 'dbname=postgresscanner' AS postgres_db (T... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- CREATE MACRO Statement 7873
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...Overloads Overloads for macro functions have to be set at creation, it is not possible to define a macro by the same name twice without first removing the first definition. Recursive Functions Defining recursive functions is not supported. For exampl... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- JSON Processing Functions 7477
- JSON Extraction Functions There are two extraction functions, which have their respective operators. The operators can only be used if the string is stored as the JSON logical type. These functions support the same two location notations as
...racted from the same JSON, it is more efficient to extract a list of paths: The following will cause the JSON to be parsed twice: Resulting in a slower query that uses more memory: SELECT json_extract(j, 'family') AS family, json_extract(j, 'species')... - https://man.mtool.work/duckdb/2.0/data/json/json_functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work