/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 vote280 views1 answer
Oracle create index if not exists
SQL
2 votes299 views1 answer
Set auto increment from 1
SQL
3 votes269 views4 answers
Show columns from table
SQL
0 vote290 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
3 votes278 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote309 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
-1 vote281 views3 answers
Create temp table in sql
SQL
2 votes279 views2 answers
Select list is not in group by clause
SQL
5 votes286 views3 answers
Select tables from mysql database
SQL
0 vote268 views1 answer
Oracle list chain steps
SQL