From TS2017@emirates.com Mon, 02 Jul 2001 01:17:14 -0700 From: Amar Kumar Padhi Date: Mon, 02 Jul 2001 01:17:14 -0700 Subject: RE: Simple SQL Query Question Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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:abiy.alemu@criltechnology.com]Sent: Monday, July 02, 2001 11:30 AMTo: Multiple recipients of list ORACLE-LSubject: 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 abiy.alemu@criltelecom.com Database Administration Engineer Groupe CRIL TECHNOLOGY France