22,209
社区成员
发帖
与我相关
我的任务
分享
;with cte as
(
select sale_amt - sale_ret_amt as rsale_amt from tmp_t_pos_pay_total GROUP BY rsale_amt)
SELECT SUM(DISTINCT rsale_amt ) AS rsale_amt _sum
FROM cte
GROUP BY rsale_amt _sum
SELECT SUM(DISTINCT ( sale_amt - sale_ret_amt )) AS rsale_amt
FROM tmp_t_pos_pay_total
GROUP BY rsale_amt