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
]
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
.
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
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
4 matches
Mail list logo