Random rows in SQL Server

Question

How to get random set of rows from table in sql server..?

Manish Kumar Choudhary · Answer

Hi Venkat Kumar  u can use following query SELECT TOP 5 * FROM tblstudent-- ORDER BY NEWID() just increase/decrease the number of number of rows as pr ur need..