Multiple COUNT SELECTS from the same table in one

Question

how to do multiple COUNT(*) SELECTS from the same table in one ...

$query = "SELECT count(*) FROM content_form WHERE read_flag = 0 ";  
$query = "SELECT count(*) FROM content_form WHERE read_flag = 1 "; 
$query = "SELECT count(*) FROM content_form WHERE read_flag = 0 ";

Query 1 and 3 are exactly equivalent. Take a look at http://stackoverflow.com/questions/12789396/how-to-get-multiple-counts-with-one-sql-query — Xatenev, Dec 02 '16 at 10:12

score 3 · Accepted Answer · answered Dec 02 '16 at 10:29

3

Try this

SELECT read_flag,count(read_flag) as cnt FROM content_form WHERE read_flag IN (0,1,....) GROUP BY read_flag

answered Dec 02 '16 at 10:29

PravinS

2,640
3
21
25

Akshey Bhat · Answer 2 · 2017-12-13T03:20:00.947

2

    $query = "SELECT sum(Case when read_flag=0 then 1 else 0 end) as ReadFlag0Cnt, 
                     sum(Case when read_flag=1 then 1 else 0 end) as ReadFlag1Cnt
              FROM content_form";
You can use case statement

edited Dec 13 '17 at 03:20

answered Dec 02 '16 at 10:15

Akshey Bhat

8,227
1
20
20

1

@AkshayBhat - Instead of COUNT, it should be SUM - $query = "SELECT SUM(Case when read_flag=0 then 1 else 0 end) as ReadFlag0Cnt, SUM(Case when read_flag=1 then 1 else 0 end) as ReadFlag1Cnt FROM content_form"; – Ganesh Gadge Dec 11 '17 at 10:43

score 2 · Answer 3 · edited Dec 02 '16 at 10:29

2

You may try this:

$query = "select (SELECT count(*) FROM content_form WHERE read_flag = 0) 
as flag0, (SELECT count(*) FROM content_form WHERE read_flag = 1) as flag1,
(SELECT count(*) FROM content_form WHERE read_flag = 0) as flag0) from content_form";

edited Dec 02 '16 at 10:29

Smita Ahinave

1,901
7
23
42

answered Dec 02 '16 at 10:19

Alberto

1,423
18
32

Multiple COUNT SELECTS from the same table in one

3 Answers3