SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

query to find the top ranked student in each class ?? table given

782576Jul 1 2010 — edited Jul 2 2010

i/p table:

studentid classid marks
1 1 400
2 1 500
3 2 600
4 2 700
5 3 800
6 3 900

o/p table :
studentid classid marks
2 1 500
4 2 700
6 3 900

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2010

Added on Jul 1 2010

13 comments

1,664 views