VERIFICA ALLARME PER STAZIONE: Monza Parco - 25
SQL PER RAFFICA: SELECT * FROM DatiStazioniDrop WHERE CAST(WHighSpeed as DECIMAL(5,2))=( SELECT max(CAST(WHighSpeed AS DECIMAL(5,2))) FROM DatiStazioniDrop WHERE idStazione=25 AND ora>'02:11:51' AND data='2018-01-20') AND data='2018-01-20' and ora>'02:11:51' AND IdStazione=25;
TIMESTAMP 1 ora fa: 2018-01-20 02:11:51
TIMESTAMP 12 ore fa: 2018-01-19 15:11:51
Raffica osservata:
1516417911 - Stazione: 25 - NESSUN ALLARME