SQL queries on tables: Difference between revisions

From RadiWiki
Jump to navigation Jump to search
No edit summary
(Redirected page to Chapter 13#SQL queries on tables)
 
(27 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.
 
[[Category:RadiMation]]
[[Category:Report generator]]

Latest revision as of 13:18, 22 December 2015