Table Sample
Description
The TABLESAMPLE
statement is used to sample rows from the table.
Syntax
TABLESAMPLE ( num_rows ROWS )
Note: Currently, only sample specific number of rows is supported.
Parameters
num_rows
ROWS
num_rows is a constant positive to specify how many rows to sample.
Examples
SELECT * FROM src TABLESAMPLE (5 ROWS)