i have a table marks having feilds application_no, qualification,y ear,maxmarks,ob tainedmarks.
in this each year's marks are entered for each qualification andn application.
i want to get maximum of percentages and the qualification for each application. can anybody help me.

thanks in advance.