Random rows in SQL Server
How to get random set of rows from table in sql server..?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Manish Kumar ChoudharyPosted Dec 12, 2014, 7:21 AM
u can use following query
SELECT TOP 5 *
just increase/decrease the number of number of rows as pr ur need..