RE: Simple SQL Query Question

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Mon, 02 Jul 2001 01:17:14 -0700
Message-ID: <F001.0033ED07.20010702005642@fatcity.com>

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 <FONT face=Courier color=#0000ff
size=2>where station = 'xxxx';
 
<SPAN
class=248073507-02072001>rgds
<SPAN
class=248073507-02072001>amar

<FONT face="Times New Roman"

  size=2>-----Original Message-----From: ALEMU Abiy   [mailto:abiy.alemu_at_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 :
<SPAN

  class=270522206-02072001> 
<SPAN

  class=270522206-02072001>Station          Emission_Freq       
  Reception_Freq
<SPAN

  class=270522206-02072001>--------        
  -----------------        
  ------------------

<SPAN

  class=270522206-02072001>STAT1       

  192.5                        

  193.5
<SPAN

  class=270522206-02072001>STAT2          193   
<SPAN

  class=270522206-02072001>STAT2          194
<SPAN

  class=270522206-02072001>STAT2       

  193.5                        

  194.5
<SPAN

  class=270522206-02072001>STAT2          195
<SPAN

  class=270522206-02072001> 
<SPAN

  class=270522206-02072001> 
  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 ?
<FONT face=Arial color=#ff0000

  size=2>------------------------------------------------------------------------------------

  @biy @lemu
<A

  href="mailto:abiy.alemu_at_criltelecom.com">abiy.alemu_at_criltelecom.com
<SPAN

  class=630595213-05042001>Database Administration   Engineer
<IMG height=17

  alt="Groupe CRIL TECHNOLOGY" hspace=0   src="http://www.criltechnology.com/images/cril.gif" width=177 align=top   NOSEND="1">
  France
    Received on Mon Jul 02 2001 - 03:17:14 CDT