SQL queries on tables: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
| Line 9: | Line 8: | ||
'SELECT * FROM AD CHANNEL 8,7,6,5,4,3,2,1 TABLE WHERE FREQUENCY >= 1 and FREQUENCY <= 20E6 order by Frequency desc' | '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. | => 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]] | |||
Revision as of 11:09, 8 March 2007
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.