RE: Simple SQL Query Question

[Amar Kumar Padhi]

select count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 0)
             then 1 else null end)) * 2 +
       count((case when (nvl(emission_freq, 0) != 0 and nvl(reception_freq, 0) != 0)
             then null else 1 end)) * 1 as "total"
from am39

where station = 'xxxx';

 

rgds

amar

-----Original Message-----
From: ALEMU Abiy [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 11:30 AM
To: Multiple recipients of list ORACLE-L
Subject: Simple SQL Query Question

I've a table with the following structure and sample data :

 

Station        Emission_Freq        Reception_Freq

--------        -----------------        ------------------

STAT1        192.5                        193.5

STAT2        193   

STAT2        194

STAT2        193.5                        194.5

STAT2        195

 

 

And I would like to select the number of frequencies, sort of count(*), for a given station and multiply that value by 2 if the station has Emission frequency and reception frequency and multiply by one if the station has only the emission frequency or only the reception frequency.  I don't know how to use a condition in SQL.  I'm sure that it's possible to do it but I don't know how.  Can anybody help me ?

------------------------------------------------------------------------------------

@biy @lemu

[EMAIL PROTECTED]

Database Administration Engineer

France