/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 vote371 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
1 vote301 views3 answers
Postgresql connect to database
SQL
1 vote291 views3 answers
Remove unique key from a table
SQL
9 votes317 views5 answers
Sql limit
SQL
0 vote299 views2 answers
Php convert dbf to mysql
SQL
0 vote366 views3 answers
Constraint sql
SQL
0 vote308 views1 answer
Laravel eloquent get generated sql
SQL
0 vote313 views1 answer
First Step in installing SQL workbench
SQL
0 vote313 views2 answers
Postgres another version
SQL
0 vote328 views1 answer
Soql update query
SQL