Getting error: Subquery returns more than 1 value

Question

I just run this query:

select 
    sc.Studentid as [Student ID], StudentName, semester, 
    sum(c.credit) as Creditsemester,
    cast(sum(w.[Weight]*c.credit) / sum(c.credit) as decimal(5, 2)) as [Semester GPA],
    (select sum(c.credit) from StudentScore) as cumulativecredit
from 
    StudentScore sc 
join 
    Student s on s.Studentid = sc.Studentid
join 
    Course c on sc.CourseID = c.CourseID
join 
    [weight] w on sc.Grade = w.GRADE
group by 
    sc.semester, sc.Studentid, s.StudentName

and I get this error:

Msg 512, Level 16, State 1, Line 163
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Any ides for solving this?

Sample data, desired results, and a simpler query would all help. — Gordon Linoff, Nov 01 '20 at 13:21
The error is telling you the problem here; what about the error don't you understand so we can explain it further. — Thom A, Nov 01 '20 at 13:29

score 0 · Answer 1 · answered Nov 01 '20 at 13:21

This is malformed:

  (select sum(c.credit) from StudentScore) as cumullativecredit

I'm not sure what you intend, but you have a reference to the outer query here. Because the outer query is an aggregation query, the sum() refers to the outer query, so this is not an aggregation query.

It is quite unclear what you want to do. If you referred to the table in the subquery, this would not generate that error:

  (select sum(ss.credit) from StudentScore ss) as cumulativecredit

Getting error: Subquery returns more than 1 value

1 Answers1