>This is one interesting behavior.
>
>SELECT NAME,MESSAGE FROM MESSAGE ORDER BY 2 DESCENDING TOP 50 INTO CURSOR TEMP
>
>The question is:
>
>Do you think we will have the first 50 name having the highest number of message or not?
>
>My result is given 51 because I have 3 people having the same number of message from 49, 50 and 51 ranked.
>
>How can we use TOP 50 and have only the first 50?
Seems fair for your purpose. But what if there were 10000 peoples with the same number of messages?!
Vlad
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