SQL & PL/SQL

Hello Friends,

I want to find the the first and second maximum elements in a pl/sql table.

here 's the code ..

DECLARE
TYPE max_earnings_type IS TABLE OF NUMBER;
max_earnings_tab max_earnings_type := max_earnings_type();
v_count number := 0;
v_max_earnings number ;


Can any one provide me how to find the first max and second maximum in the given table type.

appreciate your help.

thanks/kumar

Edited by: kumar73 on Oct 21, 2010 9:42 AM