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:18:12' AND data='2018-01-21') AND data='2018-01-21' and ora>'02:18:12' AND IdStazione=25;
TIMESTAMP 1 ora fa: 2018-01-21 03:38:12
TIMESTAMP 12 ore fa: 2018-01-20 16:38:12
Raffica osservata:
1516509492 - Stazione: 25 - NESSUN ALLARME