Results of 1 - 7 of about 7 for course (0.002 sec.)
- Subqueries – DuckDB 11941
- 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
...r_on_multiple_rows is set to false , in which case a row is selected randomly). Consider the following table: Grades grade course 7 Math 9 Math 8 CS CREATE TABLE grades ( grade INTEGER , course VARCHAR ); INSERT INTO grades VALUES ( 7 , 'Math' ), ( 9 ,...ELECT min ( grade ) FROM grades ; min(grade) 7 By using a scalar subquery in the WHERE clause, we can figure out for which course this grade was obtained: SELECT course FROM grades WHERE grade = ( SELECT min ( grade ) FROM grades ); course Math Subquer...as an uncorrelated subquery as well. For example, we can use it to figure out if there are any grades present for a given course: SELECT EXISTS ( FROM grades WHERE course = 'Math' ) AS math_grades_present ; math_grades_present true SELECT EXISTS ( FRO... - https://man.mtool.work/duckdb/1.3/sql/expressions/subqueries.html
- GROUPING SETS – DuckDB 11941
- 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
...tion GROUPING SETS perform the same aggregate across different GROUP BY clauses in a single query. CREATE TABLE students ( course VARCHAR , type VARCHAR ); INSERT INTO students ( course , type ) VALUES ( 'CS' , 'Bachelor' ), ( 'CS' , 'Bachelor' ), ( 'C...S' , 'PhD' ), ( 'Math' , 'Masters' ), ( 'CS' , NULL ), ( 'CS' , NULL ), ( 'Math' , NULL ); SELECT course , type , count ( * ) FROM students GROUP BY GROUPING SETS (( course , type ), course , type , ()); course type count_star(...2 CS NULL 5 NULL NULL 3 NULL Masters 1 NULL Bachelor 2 NULL PhD 1 In the above query, we group across four different sets: course, type , course , type and () (the empty group). The result contains NULL for a group which is not in the grouping set for... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/grouping_sets.html
- Performance Guide – DuckDB 8379
- 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
...automatically achieve high performance by using well-chosen default configurations and having a forgiving architecture. Of course, there are still opportunities for tuning the system for specific workloads. The Performance Guide's page contain guidelin...on Guides Copy Markdown aims automatically achieve high using well chosen default configurations forgiving architecture Of course there still opportunities tuning system 関連するページ Data Import Environment Benchmarks My Workload Is Slow DuckDB Envir... - https://man.mtool.work/duckdb/1.3/guides/performance/overview.html
- Excel Export – DuckDB 7888
- 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
...them appear as TRUE and FALSE in Excel. All other types are cast to VARCHAR and then written as text cells. But you can of course also explicitly cast columns to a different type before exporting them to Excel: COPY ( SELECT CAST ( a AS VARCHAR ), b FR... - https://man.mtool.work/duckdb/1.3/guides/file_formats/excel_export.html
- Avro Extension – DuckDB 7833
- 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
...NULL as a union of the actual type with a special NULL type. This is different to DuckDB, where any value can be NULL . Of course DuckDB also supports UNION types, but this would be quite cumbersome to work with. This extension simplifies the Avro sche... - https://man.mtool.work/duckdb/1.3/core_extensions/avro.html
- Java JDBC Client – DuckDB 7779
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...; // Arrow binding try ( var allocator = new RootAllocator (); ArrowStreamReader reader = null ; // should not be null of course var arrow_array_stream = ArrowArrayStream . allocateNew ( allocator )) { Data . exportArrayStream ( allocator , reader , a... - https://man.mtool.work/duckdb/1.3/clients/java.html
- ODBC 101: A Duck Themed Guide to ODBC – DuckDB 7779
- 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
...for Open Database Connectivity, is a standard that allows different programs to talk to different databases including, of course, DuckDB. This makes it easier to build programs that work with many different databases, which saves time as developers do... - https://man.mtool.work/duckdb/1.3/guides/odbc/general.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work