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
- 11439 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
query processing
what is a schema in sql server 2005? : Sql server database administration
how to avoid cursors? : Sql server database administration
What is sub-query in sql server? Explain its properties.
What is sql server management studio? : sql server management studio
what is create database syntax? : Sql server database administration
What is sql stored procedure?
How to rename databases in ms sql server?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is Dependency Injection and provide example?
What is rs.exe utility?
How to end a stored procedure properly in ms sql server?
What according to you is the difference between mysql and sql server performance?
Explain view in sql server?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
