General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only