I am trying to execute the below cursor and getting the error message 'Inconsistent Grouping'.
Code:
SELECT COL1, B.COL2,
SUM(CASE COL5 WHEN 'AAAAA' THEN 1
ELSE 0 END ) AS COVG,
CASE COL5 WHEN 'AAAAA' THEN COL6
ELSE ' ' AS FORM
FROM TABLE1 A,
TABLE2 B
WHERE A.COL1 = B.COL1
GROUP BY COL1, B.COL2
WITH UR
;
I want to display the value of COL6 when value in the COL5 is equal to 'AAAAA' for a particular row fetched from TABLE2.
well that's exactly what it is.
btw, you missed an END when copying.
Code:
SELECT COL1, B.COL2,
SUM(CASE COL5 WHEN 'AAAAA' THEN 1
ELSE 0 END ) AS COVG,
CASE COL5 WHEN 'AAAAA' THEN COL6
ELSE ' ' END AS FORM
FROM TABLE1 A,
TABLE2 B
WHERE A.COL1 = B.COL1
GROUP BY COL1, B.COL2 ,CASE COL5 WHEN 'AAAAA' THEN COL6 ELSE ' ' END
WITH UR
will give you another result. but then the sum COVG probably isn't what you want