Wednesday, 21 August 2013

How to count total enable and disable row from one query?

How to count total enable and disable row from one query?

eg.
id name age status
1 aaa 10 1
2 bbb 20 0
3 ccc 30 1
Now how to count total status of 1 and 0 from single query.
Ans will be 1 => 2 and 0 => 1

No comments:

Post a Comment