/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

2 votes138 views2 answers
Python escape string for sql
SQL
5 votes118 views3 answers
Sql make column nullable
SQL
0 vote116 views2 answers
Sql query inner join 3 tables
SQL
0 vote110 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote114 views1 answer
Multiple left join mysql
SQL
0 vote131 views3 answers
Run sql command line
SQL
0 vote163 views1 answer
CONVERT time string into 12 hours in sql
SQL
-1 vote116 views1 answer
Partial search in sql
SQL
5 votes137 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote107 views1 answer
Selecting Data in SQL - Select Data
SQL