Sybase:
SET rowcount 10
SELECT column FROM table

##</code><code>##

MySQL:
SELECT column FROM table
LIMIT 10