A question about "case when"
i have the following table
create table test(
id integer primary key,
category text,
rating integer
)
the "rating" column takes value 1 to 5,
I need to get number of 1 to 5 rated records for each category and for
this i used the query,
select
category,
sum(case when rating=1 then 1 else 0 end) as onestar,
sum(case when rating=2 then 1 else 0 end) as twostar,
sum(case when rating=3 then 1 else 0 end) as threestar,
sum(case when rating=4 then 1 else 0 end) as fourstar,
sum(case when rating=5 then 1 else 0 end) as fivestar
from test1
group by category
i also tried the following query which also worked
select
category,
sum(rating=1) as onestar,
sum(rating==2) as twostar, //both =and == work
sum(rating=3) as threestar,
sum(rating=4) as fourstar,
sum(rating=5) as fivestar
from test1
group by category
which of the queries is better? are the two queries just the same behind
the scenes?
Thanks,
Karthik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
