Ajax,From the OP’s comments they don’t care which records are returned, so long as there are only 10. In the initial post they would drop the 11th record. If the data happened to have records 10 and 11 with the same value, either one would do, so no logic to follow, no rule to apply
So adding an additional order by and reversing the order of selection should do the job
Select top 10 sales,id
From mytable
Order by sales,Id
Thanks, that worked perfectly.
Glad to help
I'll just point out that took 16 posts and a lot of peoples time, all because you didn't provide the information requested. For the future when you are asking about something, provide the required information - typically example source data, the query sql and the required outcome. Your first post did not provide any of this, your third alluded to there might be another field (in fact there were two), but not clear whether you were using it. In short, don't describe your data/problem, show it.