how we can find the maximum qualification in a table

Question

if any table contains the multiple rows with same id and different qualification means one row id 123 and qualification 10 th second row id 123 qualification 12 th third row id 123 qualification ba then how we can get the maximum qualification

Munesh Sharma · Answer

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;

sudheer kumar · Answer

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

sudheer kumar · Answer

my exact question is that

Israel · Answer

Can you explain well your question. Cant understand...