/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 vote160 views1 answer
Oracle sql procedure return value
SQL
2 votes158 views1 answer
When matched in sql server
SQL
0 vote226 views2 answers
Mysql cast to varchar
SQL
0 vote239 views1 answer
Mysql collation portugues brasil
SQL
2 votes168 views1 answer
Mysql last 7 days including today
SQL
5 votes174 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
1 vote141 views2 answers
Get date from datetime postgresql
SQL
0 vote245 views1 answer
Mariadb hours between two dates
SQL
0 vote175 views2 answers
Identity column in sql server
SQL
0 vote171 views1 answer
Sqlcmd no headers
SQL