Sybase:
SET rowcount 10
SELECT column FROM table