Table Sample

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)