Is there a function like for multiplying grouped values ... ?

2002-04-18 Thread Christian Rabe
Say, I have a table (simple case): +--+---+ |id|val| +--+---+ | 1| 10| | 1| 20| | 2| 5| | 2| 5| | 2| 10| +--+---+ SELECT id, MUL(val) FROM above_table GROUP BY id; I would get: ++---+ | id| MUL(val)|

Re: Is there a function like for multiplying grouped values ... ?

2002-04-18 Thread Rafal Jank
SELECT id, MUL(val) FROM above_table GROUP BY id; I would get: ++---+ | id| MUL(val)| ++---+ | 1|200| | 2|250| ++---+ ** I know there is now function MUL(), but is there anything comparable ? Nope, you