/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

1 vote166 views1 answer
Postgresql update auto_increment value
SQL
0 vote139 views1 answer
Sql get count without group by
SQL
0 vote148 views1 answer
Sql get guid
SQL
23 votes149 views4 answers
How to uninstall postgresql in ubuntu
SQL
24 votes133 views2 answers
Alter table delete column
SQL
0 vote183 views1 answer
Generate random & unique mysql string
SQL
1 vote144 views1 answer
Rails run native ssql query
SQL
0 vote140 views2 answers
How to update date in oracle
SQL
0 vote125 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote143 views1 answer
Enable outgoing remote MySQL access
SQL