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>
France
cril.gif
Received on Mon Jul 02 2001 - 01:48:45 CDT
