/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 vote122 views1 answer
Get who is hired in specific month in sql
SQL
14 votes133 views5 answers
Sql oracle limit
SQL
0 vote127 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote124 views1 answer
Mysql update sum same table
SQL
0 vote136 views1 answer
Add unique constraint sql server multiple columns
SQL
6 votes130 views2 answers
Mysqldump password in file
SQL
0 vote146 views1 answer
Pl/pgsql declare variable
SQL
0 vote164 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote125 views1 answer
Xampp mysql version
SQL
0 vote154 views1 answer
Mssql find deadlocks
SQL