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.

No comments:

Post a Comment