how to limit and order by in MS SQL?

Question

I'm familiar with MySQL but not in MS SQL,

In MySQL the query will be like this:

SELECT * from tablename ORDER BY RAND() LIMIT 5

The above query gives a 5 random number of result from the table. The same query how can i do with MS SQL?

Answer 1

Try,

SELECT TOP 5 * from tablename ORDER BY NEWID()

• NEWID()