select top 5 * from emp order by newid()
my question is , how this query get executed?
- 5 Answers
- 9816 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 points to remember while using the fillfactor argument?
Can we check locks in database? If so, how can we do this lock check?
Does server sql treat char as a variable-length or fixed-length column?
How to get the definition of a view out of the sql server?
Can a table have 2 foreign keys?
What sql server means?
What are extended events in sql server?
In what version of sql server were synonyms released?
List some advantages and disadvantages of stored procedure?
What is model database? : SQL Server Architecture
Can I disable or restrict ssrs export formats (rendering formats)?
how to take backup bcp out for a column in table in sql server?
How do we synchronize On-Premise SQL server with SQL Azure?
What is an expensive query?
What does it mean to manipulate data?
