查询冗余数据

-- 冗余数据
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 ;