将测试进行到底!
SQL：在同一表中统计订单支付成功率（%）
上一篇 /
下一篇 2012-07-09 13:57:31
/ 个人分类：load runner使用技术
--成功率：支付成功1/所有订单总数*100%
select SUM(支付成功的总数量)/CAST(SUM(所有订单总数量) AS DECIMAL(6,2))*100 as '订单成功率'
from
(
select COUNT(*) as 所有订单总数量,0 支付成功的总数量 from OrderInfo where id >788
union all
select 0 所有订单总数量,COUNT(*) 支付成功的总数量 from OrderInfo where OrderDetailStatus='1' and Id >788
) a |
select sum(case when rderDetailStatus='1' then 1 else 0 end) as '支付成功',
COUNT(*) as '总订单',
sum(case when rderDetailStatus='1' then 1 else 0 end)/CAST(COUNT(0) AS DECIMAL(6,2))*100 as '订单成功率'
from OrderInfo
where id >788; |
收藏
举报
TAG:
