Showing posts with label How can select random rows in sqlserver. Show all posts
Showing posts with label How can select random rows in sqlserver. Show all posts

Jun 3, 2011

How can select random rows in sqlserver

if you want select records from sqlserver data table randomly use that statement.

select top n * from table_name order by NEWID()

 n=number of records do you want to select once.