subject:"\[PHP\] ADV SQL Help Needed."

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 foll

Re: [PHP] ADV SQL Help Needed.

2003-01-21 Thread [-^-!-%-

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 > Subjec

Re: [PHP] ADV SQL Help Needed.

2003-01-21 Thread Tim Ward

ROTECTED]> 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 val

[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 whe