|
|
(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.
| |