SyntaxFix
Write A Post
Hire A Developer
Questions
Querying a simple subquery sorted descending, followed by sorting on the same column ascending does the trick.
SELECT * FROM (SELECT TOP 200 * FROM [table] t2 ORDER BY t2.[column] DESC) t1 ORDER BY t1.[column]