Smart Trivandrum GPS future data removal query

Sometimes GPS devices sends future data to the server and there will be request from the agencies to delete such data. Following query can be used to clear the data:

DELETE FROM st_water_gps_data WHERE sgd_imei='865006046684263' AND sgd_time>'2025-06-11 11:19:00'

Replace the sgd_imei and sgd_time fields with relevant values.