...
ORDER BY field1, field2
LIMIT 10

-- with OFFSET

LIMIT 10 OFFSET 1

-- implicit OFFSET (MySQL)

LIMIT 10,1

##</code><code>##

...
FROM table1 a, table2 b
WHERE rownum <= 10
...

##</code><code>##

SELECT TOP 10 field1, field2, ... ,fieldn
FROM ...