> I have table account (see below). 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?

How about this:

select
  (select count(*) from account where status = 'received') as
count_received,
  (select count(*) from account where status = 'send') as count_send,
  (select count(*) from account where status = 'cancelled') as
count_cancelled

You could also build a stored proc that looped over a list of the values to
find, or, I think maybe, over the actual distinct values in the field. Not
so sure about that part.

Dave Merrill

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

Reply via email to