Loading

Return Random Records From SQL Server Table

Rahul Kumar Saxena

Suppose you have a table in SQL Server as in the following:

table
Image 1.

You want to get 5 random records on every select request. Then use the following SQL Statement:

SELECT TOP 5 * FROM Employee ORDER BY NEWID()

Now see the result:

Result
Image 2.

Now again execute the query:

Execute your Query
Image 3.

output
Image 4.

SQL Server SQL Tablerandom records from SQL TableSQL random records

Comments

Join the conversation! Your thoughts help the community grow.