Thoughts

10g (1) 11c (1) 11g (5) 12c (4) 3.0 (1) ApEx (4) Cloud (11) database (10) DBA (1) EBR (1) EC2 (2) education (3) ExaData (1) F2F (1) Forms (7) java (1) language (2) memorabilia (2) Metalink vs MOS (4) multi-cultural (3) on-line communities (1) oracle (7) performance (5) projects (1) reciproke (1) Reports (2) RUP (1) sales (2) services (5) silence (1) SOA (3) SQL Server (2) standards (6) Sun (1) support (6) W8 (1) WebLogic Server (5)

Monday, March 06, 2017

Are you trying to use GROUP BY in x++

Yes, I know, it is far from Oracle. But anyway...the syntax in the SQL world is
SELECT orderheader, sum(ordervalue)
FROM some_table
WHERE some criterias
GROUP BY orderheader
But when in x++ the order is another...
SELECT orderheader, sum(ordervalue)
FROM some_table
GROUP BY orderheader
WHERE some criterias

 I mean...come on! What the ...well. What is going on?

No comments: