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

What is a benefit of using an after insert trigger over using a before insert trigger?

967

What is a matrix in ssrs?

151

What are the kinds of subquery?

998

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

990

What is the simplest way to create a new database in ms sql server?

990

What is sql server management studio? : sql server management studio

1062

Differentiate between sql temp table vs table variable?

865

What are the difference between “where” and “having” clause in sql server?

1051

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

1024

What is the difference between resultset and resultsetmetadata?

937

Can we use pragma autonomous_transaction in trigger?

940

Is foreign key unique?

985

What are the disadvantages of indexes?

1070

What are the two authentication modes in sql server?

1098

Where actually sql azure database is hosted?

163