SELECT risk_level, COUNT(*) FROM mytable GROUP BY risk_level;

----- Original Message ----- 
From: "[-^-!-%-" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 21, 2003 6:06 AM
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