Hi, I have a table and I want to select the last entries for the two device_id of 65 and 93. Help will be appreciated
device_id | time | gLa | consumed_airtime |
---|---|---|---|
65 | 2022-03-04T06:45:00.484Z | 29.807879 | 0.823296s |
65 | 2022-03-04T08:14:48.649Z | 29.770195 | 0.061696s |
93 | 2022-03-04T08:14:57.019Z | 29.770195 | 0.411648s |
65 | 2022-03-04T08:14:57.020Z | 29.807879 | 0.411648s |
65 | 2022-03-04T08:24:49.101Z | 29.770195 | 0.411648s |
65 | 2022-03-04T09:54:41.760Z | 29.770195 | 0.113152s |
93 | 2022-03-04T09:54:49.889Z | 29.807879 | 0.205824s |
65 | 2022-03-04T13:12:51.751Z | 29.770195 | 0.061696s |
65 | 2022-03-04T13:22:51.898Z | 29.770195 | 0.226304s |
93 | 2022-03-04T14:29:14.907Z | 29.8811571 | 0.411648s |