统计百分比代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】统计百分比

作者:魂魔 / 发布于2014/12/13/ 737


	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

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　统计百分比　

同语言下

可能有用的

魂魔贡献的其它代码(1)

.统计百分比