Back to Code Snippets
Select a sample of rows from a table
DuckDB allows sampling of data in your tables using a several different statistical techniques, usually to increase performance. The default sampling method is used in this case- this is a bernoulli variant where each vector has a specified chance of being included in the result set.
Execute this SQL
-- uses system sampling to select 10% of the people rows SELECT * FROM people USING SAMPLE 10%;
Copy code
Ryan Boyd
Expand
Share link