Review By:  Gary

>>>>>Begin Original Message<<<<<

I understand that the TOP statement return x number of rows or x% of rows but how does SQL Server determine which rows are returned?

>>>>>End Original Message<<<<<

Review On:  6/9/2006 1:49:09 AM

Review By:  Gary

>>>>>Begin Original Message<<<<<

I understand that the TOP statement return x number of rows or x% of rows but how does SQL Server determine which rows are returned?

>>>>>End Original Message<<<<<

The TOP n option in a Select statement will return n number of rows from the result set. So if you use Where or Join options it will return the first n rows from the results of that query.

If you use an Order By clause I have found it to always return the same rows it each time otherwise it is not guaranteed to return the same results.

Review On:  6/9/2006 1:54:56 AM