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
- 11604 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
What are clustered and non-clustered index?
What are pessimistic lock and optimistic lock?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
How to rebuild indexes with alter index ... Rebuild?
what is bit datatype? : Sql server database administration
What is row_number()?
Is mysql better than sql server?
What is the need for indexing?
How to create a trigger for insert only?
What is the difference between set and select?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Can a table have 2 foreign keys?
How you can add messages to the nt event log from within a stored procedure?
What is the difference between grant and with grant while giving permissions to the user?
How to connect of datebase with sql express.?
