Random 5 rows are selected when newid() is used.

select top 5 * from emp order by newid()

my question is , how this query get executed?

Question Posted / kb

Answer Posted / kb

Is This Answer Correct ?

12 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to use DTS package in 2000,2005,2008 in sql server

1839

How to sort the query output with order by clauses in ms sql server?

1035

What stored by the model?

1066

Explain about SQLOS?

1015

How do I partition a table in sql server?

1047

What are the system database in sql server 2005?

1051

what authentication modes does sql server support? : Sql server database administration

1119

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

how to create a scrollable cursor with the scroll option? : Sql server database administration

1096

What is difference between aggregate and analytic function?

939

What is log shipping?

964

What are the types of normalization?

1032

What is the purpose of linked server configuration in sql server?

1050

What is raid, and how it can influence database performance?

1058

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

989