Deepgreen DB

True Sampling

New in version 16.16.


Deepgreen DB has built-in support for true sampling with SQL. You can sample by either number of rows or by percentage of the table:

SELECT {select-clauses} LIMIT SAMPLE {n} ROWS;
SELECT {select-clauses} LIMIT SAMPLE {n} PERCENT;