Results of 1 - 3 of about 3 for exploring (0.001 sec.)
- SAMPLE Clause 11886
- The SAMPLE clause allows you to run the query on a sample from the base table. This can significantly speed up processing of queries, at the expense of accuracy in the result. Samples can also be used to quickly see a snapshot of the data w
...hen exploring a dataset. The sample clause is applied right after anything in the FROM clause (i.e., after any joins, but before the WHE... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/sample.html
- SELECT Statement 8352
- The SELECT statement retrieves rows from the database. Examples Select all columns from the table tbl : SELECT * FROM tbl; Select the rows from tbl : SELECT j FROM tbl WHERE i = 3; Perform an aggregate grouped by the column i : SELECT i, su
...of queries, at the expense of accuracy in the result. Samples can also be used to quickly see a snapshot of the data when exploring a dataset. The SAMPLE clause is applied right after anything in the FROM clause (i.e., after any joins, but before the whe... - https://man.mtool.work/duckdb/2.0/sql/statements/select.html
- Samples 7645
- Samples are used to randomly select a subset of a dataset. Examples Select a sample of exactly 5 rows from tbl using reservoir sampling: SELECT * FROM tbl USING SAMPLE 5; Select a sample of approximately 10% of the table using system sampli
....i USING SAMPLE reservoir(20%); Syntax Samples allow you to randomly extract a subset of a dataset. Samples are useful for exploring a dataset faster, as often you might not be interested in the exact answers to queries, but only in rough indications of w... - https://man.mtool.work/duckdb/2.0/sql/samples.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work