Results of 1 - 10 of about 13 for modifier (0.001 sec.)
- ORDER BY Clause 12915
- ORDER BY is an output modifier. Logically it is applied near the very end of the query (just prior to LIMIT or OFFSET , if present). The ORDER BY clause sorts the rows on the sorting criteria in either ascending or descending order. In addi
...ion number (where the indexing starts from 1), or the keyword ALL . Each expression can optionally be followed by an order modifier ( ASC or DESC , default is ASC ), and/or a NULL order modifier ( NULLS FIRST or NULLS LAST , default is NULLS LAST ). ORDE...e used in combination with other expressions in the ORDER BY clause – it must be by itself. See examples below. NULL Order Modifier By default, DuckDB sorts ASC and NULLS LAST , i.e., the values are sorted in ascending order and NULL values are placed la... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/orderby.html
- SQL to/from JSON 11225
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json seriali
...xamples Simple example: SELECT json_serialize_sql('SELECT 2'); {"error":false,"statements":[{"node":{"type":"SELECT_NODE","modifiers":[],"cte_map":{"map":[]},"select_list":[{"class":"CONSTANT","type":"VALUE_CONSTANT","alias":"","query_location":7,"query_...":"FUNCTION","type":"FUNCTION","query_location":9,"query_location_length":0,"function_name":"+","order_bys":{"type":"ORDER_MODIFIER"},"distinct":false,"is_operator":true,"export_state":false,"arguments":[{"expression":{"class":"CONSTANT","type":"VALUE_CO...:"FUNCTION","type":"FUNCTION","query_location":23,"query_location_length":0,"function_name":"+","order_bys":{"type":"ORDER_MODIFIER"},"distinct":false,"is_operator":true,"export_state":false,"arguments":[{"expression":{"class":"COLUMN_REF","type":"COLUMN... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
- DROP Statement 10381
- The DROP statement removes a catalog entry added previously with the CREATE command. Examples Delete the table with the name tbl : DROP TABLE tbl; Drop the view with the name view1 ; do not throw an error if the view does not exist: DROP VI
...entries that depend on it. table "t1" depends on schema "myschema". Use DROP...CASCADE to drop all dependents. The CASCADE modifier drops both myschema and myschema.t1 : CREATE SCHEMA myschema; CREATE TABLE myschema.t1 (i INTEGER); DROP SCHEMA myschema C...g dependencies are tracked and thus will raise an error if the user tries to drop the depending object without the CASCADE modifier. Depending object type Dependent object type SCHEMA FUNCTION SCHEMA MACRO TABLE SCHEMA MACRO SCHEMA SCHEMA SCHEMA SEQUENCE... - https://man.mtool.work/duckdb/2.0/sql/statements/drop.html
- Result Verification 9096
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...we might only be interested in whether or not the result contains a snippet of text. In that case, we can use the <REGEX>: modifier followed by a certain regex. If the result value matches the regex the test is passed. This is primarily used for query pl...RQUET_SCAN.*Filters: a=1 OR a=2.* If we instead want the result not to contain a snippet of text, we can use the <!REGEX>: modifier. File As results can grow quite large, and we might want to re-use results over multiple files, it is also possible to rea... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- CREATE TYPE Statement 9096
- The CREATE TYPE statement defines a new type in the catalog. Examples Create a simple ENUM type: CREATE TYPE mood AS ENUM ('happy', 'sad', 'curious'); Create a simple STRUCT type: CREATE TYPE many_things AS STRUCT(k INTEGER, l VARCHAR); Cre
...l', 'gloomy'); Syntax The CREATE TYPE clause defines a new data type available to this DuckDB instance. Use the OR REPLACE modifier to redefine a type that already exists. These new types can then be inspected in the duckdb_types table . Limitations Exte... - https://man.mtool.work/duckdb/2.0/sql/statements/create_type.html
- DELETE Statement 8885
- The DELETE statement removes rows from the table identified by the table-name. If the WHERE clause is not present, all records in the table are deleted. If a WHERE clause is supplied, then only those rows for which the WHERE clause results
...The RETURNING clause allows returning the deleted values. It uses the same syntax as the SELECT clause except the DISTINCT modifier is not supported. CREATE TABLE employees (name VARCHAR, age INTEGER); INSERT INTO employees VALUES ('Kat', 32); DELETE FRO... - https://man.mtool.work/duckdb/2.0/sql/statements/delete.html
- LIMIT and OFFSET Clauses 8674
- LIMIT is an output modifier. Logically it is applied at the very end of the query. The LIMIT clause restricts the amount of rows fetched. The OFFSET clause indicates at which position to start reading the values, i.e., the first OFFSET valu
... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/limit.html
- CREATE INDEX Statement 8252
- CREATE INDEX The CREATE INDEX statement constructs an index on the specified column(s) of the specified table. Examples Create a unique index films_id_idx on the column id of table films : CREATE UNIQUE INDEX films_id_idx ON films (id); Cre
...not exist. name The name of an index to remove. Syntax Limitations The CREATE INDEX clause does not support the OR REPLACE modifier.... - https://man.mtool.work/duckdb/2.0/sql/statements/create_index.html
- UPDATE Statement 7830
- The UPDATE statement modifies the values of rows in a table. Examples For every row where i is NULL , set the value to 0 instead: UPDATE tbl SET i = 0 WHERE i IS NULL; Set all values of i to 1 and all values of j to 2: UPDATE tbl SET i = 1,
...clause returns the values of the rows that were updated. It uses the same syntax as the SELECT clause, except the DISTINCT modifier is not supported. The returned values reflect the state of the rows after the update. CREATE TABLE tbl (i INTEGER, j INTEG... - https://man.mtool.work/duckdb/2.0/sql/statements/update.html
- CREATE TABLE Statement 7196
- The CREATE TABLE statement creates a table in the catalog. Examples Create a table with two integer columns ( i and j ): CREATE TABLE t1 (i INTEGER, j INTEGER); Create a table with a primary key: CREATE TABLE t1 (id INTEGER PRIMARY KEY, j V
...ing: CREATE TABLE flights AS FROM 'https://duckdb.org/data/flights.csv'; The CTAS construct also works with the OR REPLACE modifier, yielding CREATE OR REPLACE TABLE ... AS statements: CREATE OR REPLACE TABLE flights AS FROM 'https://duckdb.org/data/flig... - https://man.mtool.work/duckdb/2.0/sql/statements/create_table.html
DuckDB 2.0 Documentation / man.mtool.work