统计百分比
- 作者: 灰飛湮灭
- 来源: 51数据库
- 2022-08-17
SELECT MerId, VenderName, ShoppingMonth, TotalOrderNumber, SuccessOrderNumber, TotalPayAmount, SuccessTotalPayAmount, CASE TotalOrderNumber WHEN 0 THEN '0%' ELSE CONVERT(varchar,CONVERT(DECIMAL(10,2),CONVERT(DECIMAL(16,2), SuccessOrderNumber)*1.0/CONVERT(DECIMAL(16,2), TotalOrderNumber)*100 ))+'%' END AS SuccessRate FROM Vender v LEFT JOIN GNETE_MER_STAT_MONTHS s ON v.VenderID = s.MerId WHERE ShoppingMonth BETWEEN 201403 AND 201406 AND v.Deleted = 0 GROUP BY MerId, VenderName, ShoppingMonth, TotalOrderNumber, SuccessOrderNumber, TotalPayAmount, SuccessTotalPayAmount ORDER BY MerId ASC, ShoppingMonth ASC
推荐阅读
