newid() function return random row and top 5 return top 5 rows. So query

select top 5 * from emp order by newid()

my question is , how this query get executed?

Question Posted / anil sharma

Answer Posted / anil sharma

newid() function return random row and top 5 return top 5
rows.
So query return top 5 row using random order.

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

Do you know what is a linked server in sql server?

1024

What are character string data types in ms sql server?

1252

What are ddl (data definition language) statements for tables in ms sql server?

1104

What is 'Join' and explain its various types.

1137

Explain the rules for designing files and file groups in sql server?

988

What is a collation?

1092

Explain security with sql azure?

186

What is scan table/view and seek table/view when its occurs? : sql server database administration

1048

How extra digits are handled with numeric data type literals?

966

what is the system function to get the current user's user id? : Sql server database administration

1022

Explain the creation and execution of a user-defined function in the sql server?

1051

what are acid properties? : Sql server database administration

997

What is attribute hierarchy? : sql server analysis services, ssas

1020

What is a constant or literal in ms sql server?

1046