/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 vote147 views1 answer
Sql log file inof
SQL
0 vote206 views1 answer
Sql database size
SQL
0 vote156 views1 answer
Sqlcl format
SQL
3 votes170 views3 answers
Create table in SQL Server
SQL
1 vote128 views1 answer
Deleting database in sql
SQL
0 vote163 views1 answer
Select * where id = 1,2,3
SQL
0 vote162 views1 answer
How to change the field size of an existing column
SQL
0 vote154 views1 answer
Trigger stock phpmyadmin
SQL
1 vote144 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote128 views1 answer
Mysql locate
SQL