>I think that is the wrong answer ... Standard-SQL and ANSI-SQL require that
>a column that is displayed
>and has no grouping function applied to it MUST also appear in the GROUP
>BY-clause!!!
Sir, every dialect of SQL has it's non-ANSI quirks. I've never heard
of Standard-SQL, but ANSI-SQL
I think that is the wrong answer ... Standard-SQL and ANSI-SQL require that
a column that is displayed
and has no grouping function applied to it MUST also appear in the GROUP
BY-clause!!!
The result:
fldNAME fldMONAT sum(fldSALARY)
boris 1 10200
stephan 1 6000
i
