The SQL for MSSQL transformed into following (example)
Code: Select all
SELECT * FROM
( SELECT TOP 10 ROW_NUMBER() OVER ( ORDER BY name ASC, statuspa DESC) AS RowNumber, demo_development.id FROM demo_development WHERE 1=1 ) as foo
WHERE 1=1 AND (RowNumber > 0 AND RowNumber <= 10)
ORDER BY name ASC, statuspa DESC