Home » RDBMS Server » Server Administration » help on select count statement
help on select count statement [message #370725] Sun, 23 January 2000 00:19 Go to next message
judy brown
Messages: 1
Registered: January 2000
Junior Member
have a table called ade_pole with column names of contact_01,contact_02,contact_03 and contact_04. the contacts are utility attachments that = 1phone,2phoneguy,3cable,4cableguy. how do i create statement that will tell me the number of phone attachments,phone with guys,phone with cable,cable attachement,cable w/guys, and cable or phone with cable/guy and phonew/guys? the numbers 1 thru 4 could be in any of contact_01 thru contact_04 columns.
thanks for your help.
Re: help on select count statement [message #370726 is a reply to message #370725] Sun, 23 January 2000 07:26 Go to previous message
Paul
Messages: 164
Registered: April 1999
Senior Member
Judy,
This may point you in the right direction:

SELECT count (*),
'PHONE ' as CONTACT
FROM ade_pole
WHERE contact_01 = '1phone'
OR contact_02 = '1phone'
OR contact_03 = '1phone'
OR contact_04 = '1phone'
UNION
SELECT count (*),
'PHONE GUY' as CONTACT
FROM ade_pole
WHERE contact_01 = '2phoneguy'
OR contact_02 = '2phoneguy'
OR contact_03 = '2phoneguy'
OR contact_04 = '2phoneguy'
UNION
SELECT count (*),
'CABLE ' as CONTACT
FROM ade_pole
WHERE contact_01 = '3cable'
OR contact_02 = '3cable'
OR contact_03 = '3cable'
OR contact_04 = '3cable'
UNION
SELECT count (*),
'CABLE GUY' as CONTACT
FROM ade_pole
WHERE contact_01 = '4cableguy'
OR contact_02 = '4cableguy'
OR contact_03 = '4cableguy'
OR contact_04 = '4cableguy'
UNION
SELECT count (*),
'PHONE AND CABLE' as CONTACT
FROM ade_pole
WHERE ( contact_01 = '1phone'
OR contact_02 = '1phone'
OR contact_03 = '1phone'
OR contact_04 = '1phone'
)
AND ( contact_01 = '3cable'
OR contact_02 = '3cable'
OR contact_03 = '3cable'
OR contact_04 = '3cable'
);
Hope it helps,
Paul
Previous Topic: PL SQL Tables
Next Topic: Syntax question SEQUENCES
Goto Forum:
  


Current Time: Wed Oct 21 11:55:08 CDT 2020