Special SUM Statement

Posted in 2004

Nicolas Mainczyk — Fri, 26 Mar 2004 11:11:09 +0100 — source: Usenet: comp.databases.informix

Hi, What is the equivalent statement for sum(if(condition,result1,result2)) for mysql RDBMS or CASE WHEN ... for sybase or DECODE for Oracle ? I have a statement like SELECT sum(field)/sum(items) and I got an error when sum(items)=0 (div/0 error) so I'd like to use if sum(items)=0 display 0 or NULL otherwise calculate the expression. TIA, Nicky.