/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 vote175 views1 answer
Mysql loop through databases and execute query
SQL
0 vote202 views1 answer
Order by number of character in sql
SQL
0 vote149 views2 answers
Uninstall postgresql mac
SQL
8 votes135 views1 answer
Sql limit results returned
SQL
0 vote133 views1 answer
Parsing float to int in mysql
SQL
1 vote139 views1 answer
List index mysql cli
SQL
0 vote135 views1 answer
Reading from right to left from string find first special characters in sql
SQL
1 vote130 views2 answers
Sql for date greater than
SQL
-1 vote134 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
1 vote153 views1 answer
How to convert number to hours and minutes in oracle sql
SQL