/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 vote302 views2 answers
Sql for date greater than
SQL
27 votes302 views6 answers
Sql update record
SQL
14 votes302 views1 answer
Sql value of string
SQL
0 vote298 views1 answer
Sql server set complex constraints
SQL
0 vote296 views1 answer
How to order result of subquery in select
SQL
5 votes303 views2 answers
Mysql import gzip db
SQL
4 votes335 views3 answers
Sql find second highest salary employee
SQL
1 vote294 views1 answer
List all triggers in SQL Server
SQL
1 vote299 views1 answer
Sql upsert
SQL
1 vote267 views2 answers
Procedure pl/sql
SQL