off the top of my head
SELECT risk_level, COUNT(risk_level) AS rl_count GROUP BY risk_level
should do it, though I'd have to experiment with what's inside the
COUNT().

Tim Ward
http://www.chessish.com
mailto:[EMAIL PROTECTED]
----- Original Message -----
From: [-^-!-%- <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 21, 2003 12:06 PM
Subject: [PHP] ADV SQL Help Needed.


>
> Hello everyone,
>
> I need help with the following query.
>
> I have a table with a column named 'RISK_LEVEL'.
> RISK_LEVEL can hold three values: Low, Moderate, and High.
>
> I need a query that counts the number of occurences of each option.
> Now, I know I can do
>
> 'select count(risk_level) as levelCount where risk_level=low'
>
> for each level (low, moderate, and high). But, I was wondering if there's
> anyway to merge the queries into one.
>
> I'm looking for something like
>
> "select count(risk_level='low') as lowCount,
count(risk_level='moderate')as
> modCount, count(risk_level='high') as highCount "
>
> Which will return, lowCount = 1 , modCount=3, and highCount=1, for table
> with
>
>  id | risk_level
>  1  | low
>  2  | moderate
>  3  | moderate
>  4  | high
>  5  | moderate
>
> How do you do it? Can tha be done?
>
> When I run the code above, I get the same number for each record. i.e.
> lowCount, modCount, and highCount all come out to 5--which is the number
> of records in the table.
>
> Is this possible, or should I just run multiple queries?
> Please help.
>
>
> =P e p i e  D e s i g n s
>  www.pepiedesigns.com
>  Providing Solutions That Increase Productivity
>
>  Web Developement. Database. Hosting. Multimedia.
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to