/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 vote240 views1 answer
Shrink database file in sql server
SQL
0 vote212 views1 answer
Minecraft duping allowed servers
SQL
0 vote209 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote224 views1 answer
Postgresql comandos basicos
SQL
0 vote219 views1 answer
Difference between db.query and db.execute
SQL
25 votes234 views3 answers
How to use a database to see tables mysql
SQL
0 vote231 views1 answer
SQL Server date literal
SQL
0 vote235 views1 answer
How to know if table in rigt or left in sql
SQL
2 votes211 views2 answers
Mamp connect mysql terminal
SQL
1 vote210 views1 answer
Postgresql filter on
SQL