sule

Still after the query it can only display one student. But i want display all the students in the class. I need your help.

SELECT marks.studentid, marks.studentname, marks.acayearid, marks.termid, marks.subjectid, marks.classid, marks.staffname, marks.class_score2, marks.exam_score2, marks.total, marks.grade, RANK() OVER (PARTITION BY marks.termid, marks.classid, marks.subjectid ORDER BY marks.total DESC) as pos, marks.rem FROM marks WHERE marks.subjectid='CREATIVE ARTS' OR marks.subjectid='ENGLISH' OR marks.subjectid='HISTORY' OR marks.subjectid='ICT' OR marks.subjectid='HISTORY' OR marks.subjectid='MATHEMATICS' OR marks.subjectid='SCIENCE' OR marks.subjectid='O. W. O. P.' ORDER BY marks.studentname ASC;

Please I am at a confused I need a code to generate the student position in subject SELECT marks.studentid, marks.studentname, marks.acayearid, marks.termid,marks.subjectid, marks.classid, marks.studentid, marks.staffname, marks.class_score2, marks.exam_score2, marks.total, marks.grade, marks.pos, marks.rem, RANK() OVER (PARTITION BY marks.termid, marks.classid, subjectid ORDER BY marks.total DESC) pos FROM marks;