Hi again !

In a Select SQL statement, specifying TOP nExpr or PERCENT and having ORDER BY DESCending ... will the statement parse the whole table, then order by DESC then give out nExpr

or

will the statement parse the table UNTIL it has nExpr rows regardless it has not reached EOF and then order by DESC

My table will be 100K rows and I would like to dish out only nExpr (i.e: 200) of the latest entries.

TIA

Pierre Richard