Interested to Buy Any Domain ? << Click Here >> for more details...
select top 5 * from emp order by newid()
my question is , how this query get executed?
- 5 Answers
- 11171 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 are policy management terms?
Explain indexing and what are the advantages of it?
What are the benefits and tasks of object explorer? : sql server management studio
What is nested transaction?
What are database states in ms sql server?
Explain Capacity planning to create a database? and how to monitor it?
what are the important architecture components of SSRS?
Tell me what do we need queues in sql service broker?
Explain about local stored procedure?
What is difference between rownum and rowid?
What is update_statistics command?
How to create a simple table to test triggers in ms sql server?
How to add the custom code in Report?
How do you delete duplicate rows in sql server?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
