>>
Why do you ask?>>
>>>Is SQL using TOP clause, with a order by clause, reliable?
>>>Has anyone found to it to give incorrect results?
>
>A SQL statement I use, containing the phrase'TOP 20' was reported as returning more than 20 items. It was also mentioned by a associate that the clause 'TOP' was unreliable.
>
>It is valuable to know others experience (if any) when trying to determine the cause of a problem.
>
>Thanks!
Jeff,
It depends on your ORDER BY clause. If the field in this clause contains unique values, then you should get back the number of rows you desire. However, if they're not unique, you'll get back more.
George
Ubi caritas et amor, deus ibi est