Шпаргалка по SQL - ограничение SELECT в разных БД

[stalker_in_fire]

Postgresql:
SELECT firstname, lastname, email
FROM contacts
LIMIT 10

MS SQL Server:
SELECT TOP 10 firstname, lastname, email
FROM contacts

ORACLE:
SELECT firstname, lastname, email
FROM contacts
WHERE ROWNUM <= 10

mySQL:
SELECT firstname, lastname, email
FROM contacts
LIMIT 10