does sum (case when lev >= 50 then 1 else 0 end) as matches do what you want?
On Sun, Sep 8, 2013 at 9:12 PM, <jane...@web.de> wrote: > Hi, > > this is my query: > SELECT user, > sum(CASE WHEN lev >= 50 AND lev < 70 THEN 1 ELSE 0 END) as a, > sum(CASE WHEN lev >= 70 AND lev < 80 THEN 1 ELSE 0 END) as b, > sum(CASE WHEN lev >= 80 AND lev <= 90 THEN 1 ELSE 0 END) as c, > sum(CASE WHEN lev > 90 THEN 1 ELSE 0 END) as d, > (SELECT a + b + a + d) AS matches > FROM t_temp_fts > GROUP BY user' > > I like to add up the 4 columns a,b,c and d of every user, but it doesn't > work like this. > Does anyone know a solution > > Janek Sendrowski > -- The person who says it cannot be done should not interrupt the person who is doing it. -- Chinese Proverb