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
Explain primary key?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What is default port number for sql server 2000?
Explain for xml explicit mode?
What is database replication? What are the different types of replication you can set up in sql server?
Explain a differential backup?
Can another user execute your local temporary stored procedures?
What the different components of Replication and what is their use?
What do you understand by the analysis services in sql server?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is create statement?
What is the current pricing model of SQL Azure?
How do I make a resultset scrollable?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration