How to select N random rows using a T-SQL Query ?

AbundantCode 2 months ago in SQL Server 0

You can use the TOP keyword and specify the number to retreive the TOP N records that the query returns. Additionally , order the records by newid() function using the ORDER BY clause to make the records random.

How to select N random rows using a T-SQL Query ?

use AdventureWorks2014 
GO 
SELECT top 10  percent * 
FROM HumanResources.Employee order by newid()
image
Tags : , , , , 

Leave Your Comment