Return 2nd row in a table using select statement

[DLTaylor]

I have a table where I need to only want to return the 2nd row no matter what the values contained within the row.
Is there a simple way to do this?

Thanks

 

[r937]

Nth row" makes sense only with respect to the values in a certain column

for example, here's the row with the 2nd highest qux value:

select foo
     , bar
     , qux
  from daTable
 where qux =
       ( select max(qux)
           from daTable
          where qux <
                ( select max(qux)
                    from daTable ) )

r937.com | rudy.ca