表aaa中有相同id不同时间czsj的单,去重取最新 SELECT ssr1.* FROM aaa ssr1 LEFT JOIN aaa ssr2 ON ssr1.htbm = ssr2.htbm AND ssr1.czsj < ssr2.czsj WHERE ssr2.id IS NULL
MYSQL不用group by去重取最新
最新推荐文章于 2023-06-21 15:05:35 发布
表aaa中有相同id不同时间czsj的单,去重取最新 SELECT ssr1.* FROM aaa ssr1 LEFT JOIN aaa ssr2 ON ssr1.htbm = ssr2.htbm AND ssr1.czsj < ssr2.czsj WHERE ssr2.id IS NULL