SQL: How do I get just the first row of a result set?

[marist89]

I need to get the first row returned from a select query that looks like this:

SELECT DISTINCT parm1 FROM table1 WHERE parm1 > 10 ORDER BY parm1

Can someone please show me how to do this?

Alex

select * from (
   SELECT DISTINCT parm1 FROM table1 WHERE parm1 > 10 ORDER BY parm1 )
where rownum < 2