select top 5 * from emp order by newid()
my question is , how this query get executed?
- 5 Answers
- 9775 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankita bosamiya
first of all order by clause will be executed that is first
it will be arranged as ascending or descending order and
than first 5 records will be fatched.....
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what's the maximum size of a row? : Sql server database administration
How do I completely remove sql server instance?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
what are the different types of replication you can set up in sql server? : Sql server database administration
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What is dimension table? : sql server analysis services, ssas
What are the lambda triggers?
Explain sql server authentication modes?
what do you understand by change data capture?
What are the system database in sql server 2005?
Explain table valued parameters in sql server? Why tvp used?
What stored by the master? : sql server database administration
Is sql server 2016 free?
How to connect php with different port numbers?
How to use wildcard characters in like operations in ms sql server?
