Hi Jeff,

TOP is reliable (as far as I know) once you understand that if the Nth 'key' occurs in more than one entry, all entries with the same 'key' are included in the output.

In other words, if you say TOP 10 and the 10th-23rd all have same 'key' value, then 23 records will appear in your output.

Cheers,

Jim N

>Is SQL using TOP clause, with a order by clause, reliable?
>
>Has anyone found to it to give incorrect results?