SQL Server Random Sort or SQL query to return rows in random order

Jak

Member

858 Points

132 Posts

Hi,

How to request a random row in SQL?

Views: 8826
Total Answered: 1
Total Marked As Answer: 1
Posted On: 12-Apr-2015 21:56

Share:

Answers

Rahul M...

Teacher

4822 Points

23 Posts

Hi Jak,

Use following query:

SELECT TOP 1 * FROM mytable ORDER BY NEWID()

Posted On: 12-Apr-2015 09:41

Discussion

MVC Design pattern