Search Result: capitals - DuckDB 2.0 全文検索

Set Operations 9414: Set operations allow queries to be combined according to set operation semantics . Set operations refer to the UNION [ALL] , INTERSECT [ALL] and EXCEPT [ALL] clauses. The vanilla variants use set semantics, i.e., they eliminate duplicates, ... in one of the queries are filled with NULL values for the other query. Take the following tables for example: CREATE TABLE capitals (city VARCHAR, country VARCHAR); INSERT INTO capitals VALUES ('Amsterdam', 'NL'), ('Berlin', 'Germany'); CREATE TABLE weat ... TEGER, date DATE); INSERT INTO weather VALUES ('Amsterdam', 10, '2022-10-14'), ('Seattle', 8, '2022-10-12'); SELECT * FROM capitals UNION BY NAME SELECT * FROM weather; city country degrees date Seattle NULL 8 2022-10-12 Amsterdam NL NULL NULL Berlin Ger ...; https://man.mtool.work/duckdb/2.0/sql/query_syntax/setops.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work