-- 冗余数据
SELECT
l.*
FROM
t_lifeservice_orders l,
(SELECT
t.*
FROM
t_lifeservice_orders t
WHERE t.orderStatus = 2
GROUP BY t.orderNum,
t.orderStatus,
t.channelCode
HAVING COUNT(t.orderStatus) > 1) AS o
WHERE l.orderNum = o.orderNum
AND l.orderStatus = o.orderStatus
AND l.channelCode = o.channelCode
AND l.orderStatus = 2 ;
查询冗余数据
最新推荐文章于 2023-05-09 20:01:15 发布