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 the full result set.

Thanks for reading this article,

Next steps :

1.     Share this with your colleagues because Sharing  is Learning

        2.    Comment below if you need any assistance

Powered by CodeReview – Let’s make it Better!