/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 vote328 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote335 views1 answer
Sql recherche nom prenom
SQL
0 vote349 views1 answer
Inserting data into different tables at once in oracle sql
SQL
1 vote332 views1 answer
Create new table in SQL from old table with data
SQL
0 vote374 views1 answer
Space not removing from column in sql
SQL
0 vote353 views1 answer
Sql cmd no truncate
SQL
0 vote349 views1 answer
Reona
SQL
0 vote368 views1 answer
Print hello world in plsql
SQL
0 vote346 views1 answer
How we can perform acid Operations in sql with examples
SQL
16 votes342 views4 answers
Sort by sql
SQL