This content has been marked as final. Show 2 replies
Look at using a rollup aggregate function and delete the breaks..
This works when I run it in SQL Developer. Now I enter this for my report query in APEX and I get the "not a GROUP BY expression.
FROM t3_mail_piece t
WHERE t.week_id = 11
GROUP BY ROLLUP(t.campaign_id, t.market_id)
ORDER BY t.campaign_id
What is different?