This is an ORACLE SQL question, rather than a JDBC question. Suppose i have a table 'Table1' with the following records:
Fund :Col2: SeqNo: Col4 ======================== 1 1 1 x 1 1 2 y 2 1 5 y 2 1 6 x 1 0 3 p 2 0 4 y
The Query that would return this resultset in the order given above is: Select * from table1 order by Col2 desc,SeqNo asc. My question is how do i define a Cursor in my stored proc such that i get the last 2 (n in general) rows in the example specific above. i.e How do i define a cursor such that i get the records with the lowest Col2 (for a Fund) and the highest SeqNo for this lowest Col2 (for the fund). Please note that the record for a given Fund with the lowest Col2 may not have the highest SeqNo for the Fund (as in Record#6 and Record#4 in the example).