for example:
Problem: A table table (a, b), using the SELECT TOP 5 (*) from Table ORDER BY B, if the 5 records recorded in the 5th records is the same. Then return a record of more than 5.
Solve: Add a sort condition in the order by the order, such as a general self-increment.
This problem does not exist in SQL Server2000.