Table Sample

Description

The TABLESAMPLE statement is used to sample rows from the table.

Syntax

  1. 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

  1. SELECT * FROM src TABLESAMPLE (5 ROWS)