Difference between revisions of "SQL queries on tables"

From RadiWiki
Jump to: navigation, search
 
(Redirected page to Chapter 13#SQL queries on tables)
 
(28 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
+
#REDIRECT [[Chapter_13#SQL_queries_on_tables]]
 
 
 
 
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.
 

Latest revision as of 13:18, 22 December 2015