can we use a agregate function inside a case statement in db2?

[riyaz rajwani]

can we use a agregate function inside a case statement in db2? If yes, plz provide the syntax..

[Rabbit]

Yes you can. It's written pretty much as you describe it.

SELECT groupingField, (
   CASE WHEN groupingField = 'SingleGroup'
   THEN SUM(valueField)
   ELSE AVG(valueField)
   END) AS oddAggregation
FROM tableName