16 November 2010

SQL TOP clause and its MySQL equivalent

A note on SQL and MySQL:

SELECT TOP number|percent column_name(s)
FROM table_name


is equivalent to:

SELECT column_name(s)
FROM table_name
LIMIT number


Example:

SELECT *
FROM Persons
LIMIT 5

No comments: