Hi,
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).
Please give the Query for the cursor.