select top 5 * from emp order by newid()
my question is , how this query get executed?
Answer Posted / kb
Random 5 rows are selected when newid() is used.
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What are the different sql server versions?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
When a primary key constraint is included in a table, what other constraints does this imply?
What is difference between joins and subqueries?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
How to list all login names on the ms sql server?
Can you explain important index characteristics?
Explain filestream storage of sql server 2008?
What is @@rowcount in sql?
How to provide login information for a new odbc dsn?
How will you optimize a stored procedure optimization?
Can we hide the definition of a stored procedure from a use?
How to backup encryption key ?
What is the use of sign function?
What is set nocount on and what is set nocount off?