select * from data where sn='ds1' and pq='temp' order by id desc limit 4
idsntspqvaluesystemts
46731409 ds1 temp 31.31 1617906534 Thu 08 04 2021 20:28:54
46731398 ds1 temp 31.25 1617906512 Thu 08 04 2021 20:28:32
46731391 ds1 temp 31.25 1617906491 Thu 08 04 2021 20:28:11
46731384 ds1 temp 31.19 1617906469 Thu 08 04 2021 20:27:49

Sat Apr 20 18:21:18 2024 by walley