-- *** before: ***
-- every dialect limited rows in its own words
SELECT Name FROM country ORDER BY Population DESC LIMIT 10; -- MySQL,
--PostgreSQL, SQLite
SELECT TOP 10 Name FROM country ORDER BY Population DESC; -- MS SQL Server,
--Access
SELECT FIRST 10 Name FROM country ORDER BY Population DESC;    -- Firebird
-- Oracle needed a subquery with ROWNUM

-- *** in version 2008: ***
SELECT Name
FROM country
ORDER BY Population DESC
OFFSET 0 ROWS
FETCH FIRST 10 ROWS ONLY

-- Support: PostgreSQL 8.4, Firebird 3.0, MS SQL Server 2012 (its
-- OFFSET ... FETCH NEXT demands an ORDER BY) and Oracle 12c. MySQL and
-- SQLite still know only LIMIT, Access only TOP.