multiple count in sql

Solutions on MaxInterview for multiple count in sql by the best coders in the world

Search
showing results for - "multiple count in sql"
Antonella
28 Jan 2017
1SELECT distributor_id,
2    count(*) AS Total,
3    sum(CASE WHEN inflevel = 'exec' THEN 1 ELSE 0 END) AS ExecCount,
4    sum(CASE WHEN inflevel = 'personal' THEN 1 ELSE 0 END) AS PersonalCount
5FROM yourtable
6GROUP BY distributor_id
source
similar questions
mysql count multiple columns in one queryset sql multiple valueshow to insert multiple records at once in sql acessselect multiple row from primary key sqlsql sum multiple rowsselecting multiple columns in sqlsql count how many times a value appearssql having multiple conditionsmultiple where condition in sqlwhere sql multiple conditionssql query with multiple where conditionssql where multiple valuessql query multiple tablesselect 2 rows in sqlselect count distinct multiple columns sql serverselect query in sql for multiple valuesmulti row functions in sqlsql several orsql if statement in where clause multiple valuesmysql multiple count
queries leading to this page
count multiple rows in single sqlhow to select multiple count on different table sqlmultiple row count sqlmultiple two count results sqlcount multiple coulmns in sql serverquery multiple countsql multiple countmultiple count in one query sqlsql multiple counts in one queryhow to count multiple rows in sqlselect multiple count sqlcount function multiple criteria sqlms sql multiple count queriessql multiple countshow to count multiple where condition in sqlsql select multiple countcount multiple rows sqlcount multiple condition sqlsql count with multiple selectmultiple counts in one sql querysql how to query multiple countmultiple count operator in sqlms sql multiple count queries 2 tablescount multiple stuff sqlreturn multiple rows and count sqlsql how to select multiple countscan sql query have multiple count2 count sqlcount 28 2a 29 sql multiple conditionshow to do multiple counts in sqlmultiple count in sqlmultiple count in single sql querytwo count statements sqlcounting multiple rows in sqlsql select multiple countshow to get count of multiple rows in sqlmultiple count sqlavoid multiple count in sqlsql multiple countifmultiple count in sql