SELECT TOP 10 *
FROM table

SELECT *
FROM table
LIMIT 10
OFFSET 1

SELECT *
FROM table
LIMIT 10[, 1]