SQL queries on tables

From RadiWiki
Revision as of 11:09, 8 March 2007 by Joro (talk | contribs)
Jump to: navigation, search


In combination with the 'SQL' filter selection, also more advanced tables can be created like:

   'SELECT * FROM AD CHANNEL 4,3,2,1 LIST WHERE Frequency  > 50E6'

=> Only the frequencies above 50 MHz will be included

    'SELECT *  FROM AD CHANNEL 8,7,6,5,4,3,2,1 TABLE WHERE FREQUENCY >= 1 and FREQUENCY <= 20E6 order by Frequency desc'

=> Only the frequencies between 1 Hz and 20 MHz will be included, where the AD-channel was measured out of the specified range ('TABLE'), where the tables is reverse-sorted on the frequency column.