/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 vote285 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote350 views2 answers
Mysql insert rows to another database
SQL
0 vote274 views2 answers
Mysql regexp match word
SQL
3 votes255 views1 answer
Oracle detect invalid password
SQL
1 vote261 views1 answer
Select statement to print longest name
SQL
0 vote255 views1 answer
Wordpress sql find and replace
SQL
3 votes283 views2 answers
Sql asc
SQL
0 vote247 views1 answer
Get number of table colums in sql query
SQL
0 vote306 views1 answer
Sql date with year
SQL
3 votes300 views3 answers
Mysql auto increment after delete
SQL