about finding the nth value using a QUERY - urgent

From: <vvraghav_at_my-dejanews.com>
Date: Wed, 24 Mar 1999 05:54:42 GMT
Message-ID: <7d9umv$bov$1@nnrp1.dejanews.com>

hi ,
i am just learning sql (using sql plus 3.3 with PO7win95) . i have an assignment i have to complete - to find the nth maximum value from a given list .... say i want to find the 2nd maximum from the following list

sno (primary key) marks

1                   100
2                   102
3                   101
4                    97

the output should be (3 101) and the catch is i shouldnt use pl/sql programs , only simple queries.
(even if order by using marks, how do i print only the nth row?) vikram , india

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 23 1999 - 23:54:42 CST