/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 vote250 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
25 votes262 views5 answers
Uninstall mysql ubuntu
SQL
1 vote236 views1 answer
Can we drop a primary key
SQL
3 votes238 views2 answers
Having in mysql
SQL
-1 vote271 views5 answers
Convert sql to linq query online
SQL
8 votes261 views2 answers
How to fetch data from database without last column
SQL
0 vote255 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
1 vote280 views1 answer
Connect to mysql database ubuntu
SQL
0 vote215 views0 answer
How to connect to datbase in springboot
SQL
2 votes299 views1 answer
Mysql select true or false
SQL