[PHP] ADV SQL Help Needed.

2003-01-21 Thread [-^-!-%-
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

Re: [PHP] ADV SQL Help Needed.

2003-01-21 Thread Tim Ward
] 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

Re: [PHP] ADV SQL Help Needed.

2003-01-21 Thread [-^-!-%-
. On Tue, 21 Jan 2003, Rick Emery wrote: 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

Re: [PHP] ADV SQL Help Needed.

2003-01-21 Thread Rick Emery
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