/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 vote119 views1 answer
Increasing font and zooming in mysql workbench
SQL
4 votes109 views2 answers
Dbms_scheduler stop job
SQL
0 vote113 views1 answer
Mysql change innodb to myisam
SQL
0 vote113 views1 answer
Cast for print sql
SQL
1 vote128 views3 answers
Getdate function in postgresql
SQL
0 vote117 views1 answer
Count the table indatabase
SQL
0 vote146 views1 answer
How to fetch data from database in sql
SQL
-2 votes111 views1 answer
Modify column name in tsql
SQL
0 vote122 views2 answers
Sql query inner join 3 tables
SQL
2 votes116 views1 answer
Sql like variable
SQL