In one query statement 1

[aauxta]

This really got me and it seems really simple though:

StudentID CourseID Grade
--------- -------- -----
123 111 A
123 222 B
456 111 A
456 222 A
456 333 A

I just couldn't figure out how to use just one query to find out the studentID who has straight A only... thanks in advance guys!

 

[ej00]

Try this...


SELECT DISTINCT StudentID
FROM student_grade sg1
WHERE Grade = 'A'
AND NOT EXISTS (SELECT *
FROM student_grade sg2
WHERE sg2.StudentId = sg11.StudentId
AND Grade <> 'A'
)