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

How to select an exiting database using mssql_select_db()?

1053

What are sql dirty pages?

1081

What is difference between Datepart() and Datename() in SqlServer?

1263

What is join and name different type of joins?

1099

what are different types of backups available in sql server? : Sql server database administration

984

Which is the main third-party tool used in sql server?

995

How many non clustered indexes there can be on table ?

962

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

948

How can we improve performance by using SQL Server profiler?

1108

How do I find the sql server instance name?

1014

How much does sql server 2016 cost?

1159

What is report rendering ?

162

What is catalog views?

1121

How network traffic be reduced by using the stored procedure?

1174

Explain cdc and sql injection?

1045