SQL Server – LIMIT Clause December 28, 2011

Yes, SQL Server does not support LIMIT clause as you usually does with MySQL…

SELECT TOP 10 * FROM (SELECT TOP 20 FROM Table ORDER BY Id) ORDER BY Id DESC