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