Jerry Swanson wrote:
[...]
I need to get count of received, count of send and cound of cancelled records. I know that I can do
this in 3 queries.
#1. select count(*) from account where status='received';
#2. select count(*) from account where status='send';
#3. select count(*) from account where status='cancelled';


Is it possible to get count of each status in one query instead of 3?

This looks like it could be solved with a basic GROUP BY query:

SELECT status,count(*) FROM account GROUP BY status

--
Roger


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to