Search Postgresql Archives

Re: Sum of columns

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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, <janek12@xxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux