Nis 122010
This example shows the MS-SQL (Microsoft SQL-Server) counterpiece for the limit command of MySQL.
-- MS-SQL / SQL-Server 2005 SELECT TOP 15 * FROM ExampleTable WHERE Active = 1 ORDER BY Id DESC -- MySQL SELECT * FROM ExampleTable WHERE Active = 1 LIMIT 0,15 ORDER BY Id DESC