Gossamer Forum
Home : General : Databases and SQL :

Help with syntax fixing in SQL

Quote Reply
Help with syntax fixing in SQL
following code gives the error message: "ORA-00979: not a GROUP BY expression", how do I fix this?

select ssn, category, min_units - sum(units) "UNITS_LEFT"
from course
where category = category
group by ssn

additional info:

table course: SSN SECTION UNITS COURSE CATEGORY MIN_UNITS
Subject Author Views Date
Thread Help with syntax fixing in SQL KJones 4853 May 25, 2003, 7:21 PM
Post Re: [KJones] Help with syntax fixing in SQL
604 4564 May 26, 2003, 9:44 AM