/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

7 votes127 views1 answer
Alter table add key sql
SQL
0 vote180 views1 answer
Ajax error exception handeling
SQL
0 vote171 views1 answer
First mysql
SQL
0 vote190 views1 answer
QUERY JPQL
SQL
0 vote204 views1 answer
Postgres list tables and row counts
SQL
1 vote165 views1 answer
Oracle first row
SQL
0 vote171 views1 answer
How to put is null in where in clause
SQL
0 vote181 views1 answer
Oracle table privileges
SQL
0 vote154 views1 answer
Hive batch drop table
SQL
3 votes214 views1 answer
Oracle list invalid password logon denied
SQL