select top 5 * from emp order by newid()
my question is , how this query get executed?
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
Can we call future method from queueable?
What are the two authentication modes in sql server?
How to call stored procedure using http soap?
What is the purpose of the model database?
What does Master database contains?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
How can you fetch alternate records from a table?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
can a database be shrunk with users active? : Sql server administration
What is the use of floor function in sql server?
Can a table be moved to different filegroup?
What do you understand by SQL*Net?
Explain the functionalities that views support?
How to find tables without indexes?
How fixed length strings are truncated and padded?