mysql查询次新一条数据 

SELECT
	MAX( gp.id ) AS id,
	gp.rsv2 
FROM
	(SELECT MAX( id ) AS id, rsv2 FROM device_data GROUP BY rsv2 ) gp 
WHERE
	gp.id < (SELECT MAX( id ) AS id FROM device_data GROUP BY rsv2 ORDER BY id DESC LIMIT 1 ) 
GROUP BY
	gp.rsv2 
ORDER BY
	gp.id DESC 
	LIMIT 1
posted @ 2025-01-03 16:17  RHsama  阅读(2)  评论(0)  编辑  收藏  举报