If I have a table with two columns Person and Result that has many values:-
Person Result Tom 1 James 1 Tom 2 James 4 Tom 6 James 5 What query would I use to find the 2nd highest result each of the people achieved? I.e. the result would be Tom 2 James 4 TIA --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
