Here We Go Again
Sunday, July 24, 2011
Random result in MS SQL
To get Random result form a MS SQL table you can user newid(). This will give you random order of rows each time you run the SQL statement.
SELECT TOP 10 * FROM [table_name] Where [Where Condition] Order by NEWID()
This will give you the Random Rows from you table.
Share to Twitter
Share to Facebook
Share to Pinterest