RE: Simple SQL Query Question

From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
Date: Mon, 02 Jul 2001 02:08:10 -0700
Message-ID: <F001.0033EE09.20010702020027@fatcity.com>

I'm
using Oracle 7.3.4, so is it possible to use CASE statements ?

  <FONT face=Tahoma
  size=2>-----Message d'origine-----De : Amar Kumar Padhi   [mailto:TS2017_at_emirates.com]Envoyé : lundi 2 juillet 2001   10:57À : Multiple recipients of list
  ORACLE-LObjet : RE: Simple SQL Query
  Question
  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 color=#0000ff face=Courier
  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 color=#ff0000 face=Arial

    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 align=top

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