Re: Simple SQL Query Question

From: novicedba <novicedba_at_hotmail.com>
Date: Mon, 02 Jul 2001 01:27:41 -0700
Message-ID: <F001.0033ED70.20010702011529@fatcity.com>

SELECT
STATION,EMISSION_FREQ,RECEPTION_FREQ,DECODE(SUBSTR(NVL(TO_CHAR(RECEPTION_FREQ),'NONE'),1,1),'N',EMISSION_FREQ*1,EMISSION_FREQ*2) VALUEFROM TEST;
 
STATION    EMISSION_FREQ  

RECEPTION_FREQ     
VALUE----------         
-------------                
--------------                    
---------STAT1              
192.5                  
193.5                          
385STAT2              
192.5                                                    
192.5STAT2              194                                                       
194STAT2              
193.5                  
194.5                          
387STAT2              195                                                       

195
 
I did not understand what you meant by '<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 '
so what I have done
is
if

   
the reception_freq is null (that would mean there is only emission_freq )
then

   
value=emission_freq*1
<SPAN

class=270522206-02072001>else
   
value=emission_freq*1
end
if
<SPAN

class=270522206-02072001> 
Hope this is what
you wanted
<SPAN

class=270522206-02072001> 
cozI am anoviceOracle Certifiable DBBS
<BLOCKQUOTE dir=ltr

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A title=abiy.alemu_at_criltechnology.com href="mailto:abiy.alemu_at_criltechnology.com">ALEMU Abiy To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

  Sent: Monday, July 02, 2001 1:00 PM
  Subject: 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>
  France
    Received on Mon Jul 02 2001 - 03:27:41 CDT