Breaking News: Grepper is joining You.com. Read the official announcement!

case when with count and combining similar values in sql

Bloody Bug answered on September 3, 2020 Popularity 3/10 Helpfulness 1/10

answer case when with count and combining similar values in sql

case when with count and combining similar values in sql

Comment

SELECT 
    data.id,
    data.lastname,
    data.firstname,
    SUM(data.WebData) AS WebData,
    SUM(data.InternalData) AS InternalData,
    SUM(data.countid) AS Countid
FROM
    (
       SELECT id,lastname,
              firstname,datasource,
              CASE WHEN Datasource = 'Web' THEN Count(Datasource) ELSE 0 END WebData,
              CASE WHEN Datasource = 'Internal' THEN Count(Datasource)ELSE 0 END InternalData,
             count(id) AS Countid

        FROM Table
        GROUP BY
                 id,lastname,firstname,datasource
     ) AS data
GROUP BY 
    data.id,data.firstname,data.lastname

Popularity 3/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: case-when count sql

Link to this answer
Share Copy Link