I believe it would look something like this, didn't test it though...
Select sum(decode(fieldname,'Running',1,0)) Running,
sum(decode(fieldname,'Offline',1,0)) Offline,
sum(decode(fieldname,'Unknown',1,0)) Unknown,
count(fieldname) total
from table
-----Original Message-----
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 2:18 PM
To: CF-Talk
Subject: OT: Stupid SQL Problem (in oracle)
I need some way to convert a word into a number.
I know I've done it once before, but I can't remember what I did.
For example, I have a query that will return something like the following:
Machine1 Running
Machine2 Running
Machine3 Offline
Machine4 Running
Machine5 Offline
Machine6 Unknown
I want to get some result like this:
Running Offline Unknown Total
3 2 1 6
I know it has something to do with a sum and translating "Running" into 1,
"Offline" into a 1 and "Unknown" into a 1, I just can't remember how I did
it.
This is an oracle 8i system I'm working with.
Thanks,
Rob Edwards Phone: (502) 359-1627
Systems Management Tools Pager: (502) 478-1116
United Parcel Service Fax: (502) 359-0094
EMail: [EMAIL PROTECTED]
(2B || !2B) == ?
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
