Re: [sqlite] SELECT SUM( IF(

[Daniel K]

--- [EMAIL PROTECTED] wrote:

> Hello,
> 
> Does SQLite have kind of conditional select
> expression like:
> SELECT SUM( IF(column1='Y', column2, 0 ) FROM ... ?
> 
> 
> Rainer
> 
> 

It has the CASE expression. i.e.

SELECT sum(
CASE 
  WHEN column1='Y' THEN column2 
  ELSE 0 
END) FROM ...





                
__________________________________ 
Do you Yahoo!? 
Check out the new Yahoo! Front Page. 
www.yahoo.com