checkmofoshoduno
asked on
How can i fix this query?
I need to know why the following command would create an error, and what could be changed to fix the error:
SELECT S_NUM, SUM(S_PHQ)
FROM ORDER;
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Got it, thankk you
You can't have aggregation function with a simple field in a select statement without "group by". This is a rule.
ASKER