Photogra :: phracker
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment