how we can find the maximum qualification in a table

1st u have to make enum for qualification.. after that 1st u ll fatch ID from table..

and u insert these qualification as enum

like.. string a = select ID from Table.

after that

string b = select MAX(qualification) from table whare ID = a;

id      name   qualification

123	sudheer	10 th
123	sudheer	12 th
123	sudheer	Bsc
123	sudheer	MCA
124	ramesh	10 th
124	ramesh	12 th
124	ramesh	BA