sql代码出%比

xnaigee

于 2020-05-26 14:27:03 发布

阅读量169

点赞数

本文链接：https://blog.csdn.net/xnaigee/article/details/106355531

版权

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