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
- 11607 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 the differences between local and global temporary tables?
Explain about local stored procedure?
What happens if null values are involved in bitwise operations?
Name the different type of indexes in sql?
What is the use of sign function?
Is it possible to replicate data from sql server to oracle? : sql server replication
How can you start sql server in different modes?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What type of Index will get created after executing the above statement?
What are various aggregate functions that are available?
What’s the distinction between dropping a info and taking a info offline?
What is sql collation?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What are the differences between stored procedure and view in sql server?
What is buffer cash and log cache in sql server?
