Return the TOP 10 rows???

[rmarkarian]

Is there a way to return the top 10 result rows from a TSM SQL query? The methods below don't work.

Microsoft SQL Server

SELECT TOP 10 column FROM table

PostgreSQL and MySQL

SELECT column FROM table
LIMIT 10

Oracle

SELECT column FROM table
WHERE ROWNUM <= 10

Sybase

SET rowcount 10
SELECT column FROM table