Results of 1 - 8 of about 8 for country (0.003 sec.)
- PIVOT Statement – DuckDB 13104
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...hey may not all be omitted. Example Data All examples use the dataset produced by the queries below: CREATE TABLE cities ( country VARCHAR , name VARCHAR , year INTEGER , population INTEGER ); INSERT INTO cities VALUES ( 'NL' , 'Amsterdam' , 2000 , 1005...2000 , 8015 ), ( 'US' , 'New York City' , 2010 , 8175 ), ( 'US' , 'New York City' , 2020 , 8772 ); SELECT * FROM cities ; country name year population NL Amsterdam 2000 1005 NL Amsterdam 2010 1065 NL Amsterdam 2020 1158 US Seattle 2000 564 US Seattle 2...pivot table. If the USING clause is not included, it defaults to count(*) . PIVOT cities ON year USING sum ( population ); country name 2000 2010 2020 NL Amsterdam 1005 1065 1158 US Seattle 564 608 738 US New York City 8015 8175 8772 In the above exampl... - https://man.mtool.work/duckdb/1.3/sql/statements/pivot.html
- UPDATE Statement – DuckDB 10266
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...e the FROM clause and express joins via the WHERE clause. For example: CREATE TABLE city ( name VARCHAR , revenue BIGINT , country_code VARCHAR ); CREATE TABLE country ( code VARCHAR , name VARCHAR ); INSERT INTO city VALUES ( 'Paris' , 700 , 'FR' ), (...'Lyon' , 200 , 'FR' ), ( 'Brussels' , 400 , 'BE' ); INSERT INTO country VALUES ( 'FR' , 'France' ), ( 'BE' , 'Belgium' ); To increase the revenue of all cities in France, join the city and the c...ountry tables, and filter on the latter: UPDATE city SET revenue = revenue + 100 FROM country WHERE city.country_code = country.code AND country.name = 'France' ; SELECT * FROM city ; name revenue country_code Paris... - https://man.mtool.work/duckdb/1.3/sql/statements/update.html
- GROUPING SETS – DuckDB 9561
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...sily produce commonly used grouping sets. The ROLLUP clause will produce all “sub-groups” of a grouping set, e.g., ROLLUP (country, city, zip) produces the grouping sets (country, city, zip), (country, city), (country), () . This can be useful for produ...n is the amount of terms in the ROLLUP clause. CUBE produces grouping sets for all combinations of the inputs, e.g., CUBE (country, city, zip) will produce (country, city, zip), (country, city), (country, zip), (city, zip), (country), (city), (zip), ()...sion whenever that expression is rolled up to a super-aggregate. Syntax 関連キーワード grouping city course type aggregate country super rows street generate series students clause income count group sets query Math expressions results level passed dime... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/grouping_sets.html
- Pivot Internals – DuckDB 8693
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...es ORDER BY year ); PIVOT cities ON year IN __pivot_enum_0_0 USING sum ( population ); and finally translated into: SELECT country , name , list ( year ), list ( population_sum ) FROM ( SELECT country , name , year , sum ( population ) AS population_sum...FROM cities GROUP BY ALL ) GROUP BY ALL ; This produces the result: country name list("year") list(population_sum) NL Amsterdam [2000, 2010, 2020] [1005, 1065, 1158] US Seattle [2000, 2010, 2020] [5...20] [8015, 8175, 8772] The PhysicalPivot operator converts those lists into column names and values to return this result: country name 2000 2010 2020 NL Amsterdam 1005 1065 1158 US Seattle 564 608 738 US New York City 8015 8175 8772 UNPIVOT Internals U... - https://man.mtool.work/duckdb/1.3/internals/pivot.html
- SELECT Clause – DuckDB 7790
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...operation. Therefore, only use DISTINCT if necessary. DISTINCT ON Clause Select only the highest population city for each country: SELECT DISTINCT ON ( country ) city , population FROM cities ORDER BY population DESC ; The DISTINCT ON clause returns on... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/select.html
- Set Operations – DuckDB 7790
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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 weather ( city VARCH..., 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 Germany NULL NULL Amsterdam NULL 10 2022-10-14 UNION... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/setops.html
- Sharing Macros – DuckDB 7537
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...31562127359918655305384 name_long = 126079956280724674884063510870679874110 slug = -53458800462031706622213217090663245511 country = 143068442936912051858689770843609587944 type = 5665662315470785456147400604088879751 geo_lat = 1606081161352518212591265... - https://man.mtool.work/duckdb/1.3/guides/snippets/sharing_macros.html
- SQLite Extension – DuckDB 7500
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ing data is read directly from the SQLite tables in the file at query time. SHOW TABLES ; name actor address category city country customer customer_list film film_actor film_category film_list film_text inventory language payment rental sales_by_film_c... - https://man.mtool.work/duckdb/1.3/core_extensions/sqlite.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work