/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 vote105 views1 answer
Search all database tables for a value sqlserver
SQL
2 votes108 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote101 views1 answer
Using GROUP BY in MySQL Join Table
SQL
20 votes106 views4 answers
Reset auto increment in MySQL
SQL
3 votes104 views1 answer
Dbms_scheduler drop_job
SQL
0 vote114 views1 answer
Redudancy in SQL
SQL
0 vote106 views1 answer
Procedure excute monthly oracle
SQL
2 votes111 views1 answer
Sql column values comma separated
SQL
4 votes110 views2 answers
Oracle last day of month
SQL
0 vote119 views1 answer
Create tables from xsd to sql server database c#
SQL