SELECT
*
FROM
pmo_event_order_deal a
WHERE
NOT EXISTS (
SELECT
1
FROM
pmo_event_order_deal b
WHERE
( b.order_id = a.order_id AND b.deal_man = a.deal_man )
AND b.deal_time > a.deal_time
)
MySQL中查询所有数据,其中重复的数据中只保留最新的一条,其余的过滤
最新推荐文章于 2024-08-07 14:51:18 发布