What do you mean by Table Sample?

Posted by

To view Verified answers click on the button below.

TABLESAMPLE allows you to extract a sampling of rows from a table in the FROM clause.
The rows retrieved are random and they are not in any order. This sampling can be based
on a percentage of number of rows. You can use TABLESAMPLE when only a sampling of
rows is necessary for the application instead of a full result set.