/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

0 vote108 views1 answer
Pl/ sql change currency
SQL
0 vote145 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
4 votes107 views2 answers
Mysql alter table set column unique
SQL
1 vote105 views1 answer
Sql select row with max date
SQL
2 votes108 views1 answer
Apex execute batch job
SQL
0 vote107 views1 answer
Use mysql in java program
SQL
0 vote104 views1 answer
Trigger value from maltiple table to single table mysql
SQL
1 vote103 views1 answer
Psql human readable
SQL
1 vote109 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote107 views1 answer
Grant owner postgresql
SQL