select top 5 * from emp order by newid()
my question is , how this query get executed?
- 5 Answers
- 9846 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil sharma
newid() function return random row and top 5 return top 5
rows.
So query return top 5 row using random order.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is difference between commit and rollback when used in transactions?
What is the command dbcc checkdb used for?
What is the default port for SQL Server over a firewall?
How to receive output values from stored procedures?
Do you know what are acid properties?
What is sleeping status in sql server?
What is read uncmmited?
What are acid properties of transaction?
How to handle error or exception in sql?
What are window functions in sql server?
How to override dml statements with triggers?
Do you know spatial data types - geometry and geography in sql server 2008?
What is extent? Types of extents?
What do you mean by 'normalization'?
can SSRS reports Cache results?
