Mirosoft SQL Server vs. MySQL Server

Posted on January 2, 2011 by admin

Note to self: Minor difference between the TOP command in MSSQL and MySQL equivalent.

-- MS-SQL / SQL-Server
SELECT TOP 10 * FROM ExampleTable WHERE Active = 1 ORDER BY Id DESC

-- MySQL
SELECT * FROM ExampleTable WHERE Active = 1 LIMIT 0,10 ORDER BY Id DESC

This entry was posted in sql and tagged mssql, mysql, sql. Bookmark the permalink.