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
- 11334 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 different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is right outer join in sql server joins?
How to rebuild master databse?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What does null mean?
what are the new features in SSRS?
Can group by be used without aggregate functions?
What is cdc in sql server?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What is the purpose of self join?
Explain tables in SQL Azure?
How to apply cascading referential integrity in place of triggers?
What is an index in a database?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is sql stored procedure?
