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
- 11172 Views
- I also Faced
- E-Mail Answers
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
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
how can a database be repaired? : Sql server administration
What is difference between cte and view?
What do you understand by the denormalisation?
Explain difference between cross join and full outer join?
What is the security principal at the server level that represents your session?
What are the differences between char and nchar in ms sql server?
What is the order by used for?
How can I change procedure name in sql server?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What are the tables in sql?
Explain the creation and execution of a user-defined function in the sql server?
What is an expression in ms sql server?
Why would you use sql agent?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
