/SQL/Case when with count and combining similar values in sql

Case when with count and combining similar values in sql

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

Source: stackoverflow.com

Similar codes

10 votes222 views4 answers
Primary key sql
SQL
1 vote234 views1 answer
Install postgresql on raspberry pi
SQL
13 votes181 views2 answers
Oracle all source
SQL
0 vote243 views1 answer
Into operator in sql
SQL
0 vote251 views2 answers
How to take recent row without limit in mysql
SQL
7 votes270 views2 answers
How to create index mysql
SQL
1 vote249 views2 answers
Sql server add time to date
SQL
0 vote234 views1 answer
Find all tables where column name exists oracle
SQL
22 votes235 views4 answers
Tsql rename table
SQL
0 vote247 views2 answers
Nodejs mysql convert to plain object
SQL