/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 vote293 views1 answer
Compare subqueries oracle
SQL
1 vote273 views1 answer
DATE_SUB postgres
SQL
0 vote285 views1 answer
Drop index in sql
SQL
1 vote279 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote271 views1 answer
Mysql set column equal to another automatic
SQL
0 vote255 views1 answer
Psql no such file or directory
SQL
22 votes278 views4 answers
Mysql reset auto increment id
SQL
2 votes285 views1 answer
Creating a view SQL
SQL
0 vote312 views1 answer
Get total and distict row diff in sql
SQL
1 vote270 views1 answer
Oracle rolling back
SQL