Hello,
I am very perplexed on how to get the average grade from a list of students where some students had to take the test twice. So if there is a section 002, I need to average that grade in from the student and not their section 001. I have tried an if/else and case for the section id and also avg for the grades all in the select statement but nothing seems to get what I need. My results so far are:
Student Grade Section
1245 80 001
3658 75 001
2569 65 001
2569 72 002
select Student, Grade , SECTION
from StudentTable
group by Student, GRADE, SECTION
order by Student
If anyone could point me in the right direction. Thanks!
Get grade from max section
Posted - 2015-05-07 : 16:55:19
