Kbase P18270: SQL-92: Non-group-by expression in select clause (7641)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/11/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
A SQL query which includes a GROUP BY clause returns error 7641.
Non-group-by expression in select clause (7641)
CAUSE:
The query is not SQL-92 standard compliant.
FIX:
According to the SQL-92 standard all columns named in the GROUP BY clause must also be in the select list of the query expression, for example:
SELECT
ordernum,
SUM(price)
FROM
PUB.Orderline
GROUP BY
ordernum