Cloud & SQLSailor

Cloud, Databases & Beyond!

You want to restrict the data to be retrieved in terms with percent(%),Here is the way


You can use the clause called TableSample for this purpose.

Select * from DatabaseLog
TableSample(10 percent)

TABLESAMPLE was introduced in SQL Server 2005.

Leave a comment

Explore