i need some help in an sql query in Access 2007 although i have done it in Oracle . to understand the problem you have to take the pain of reading this whole thing :)
i have a table in this format
student_id | subject | total_marks | marks_obtained
1 Math 100...