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?

Edit
Report