Random 5 rows are selected when newid() is used.

select top 5 * from emp order by newid()

my question is , how this query get executed?

Question Posted / kb

Answer Posted / kb

Is This Answer Correct ?

12 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between delete,drop and truncate in SQL Server?

1099

How real and float literal values are rounded?

1157

What is a trigger what are the advantages of trigger?

999

What is mean by dml?

1009

Explain different types of index?

1051

what are candidate key, alternate key and composite key? : Sql server database administration

917

What are the properties of the transactions?

1119

What is a data collection table?

1007

How would you add a section to a table?

1042

How can you start sql server in different modes?

970

How do you test your database? : sql server database administration

1020

What protocol does sql server use?

942

Does windows server 2016 come with sql server?

932

How to use go command in "sqlcmd"?

1204

Tell me extended events in sql server 2008?

996