Hi Friends,
I am continuously inserting records from the websocket.
I am updating existing record time and Inserting new rcord time like the below.
2024-03-26 11:16:53 AM 2024-03-26 11:56:57 AM 2024-03-26 11:50:57 AM 2024-03-26 11:55:57 AM
If some of the records data is not coming from the websocket signal the time is not updating.Due to the data exist I am displaying in the front end showing wrong results.
So I need to compare the records reported time every time and I need to delete the least datetime or not updated time record from the table.
Please give me the correct solution for this.