统计百分比

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBasal
2016-06-07 14:57:561057semak imbas

无详细内容 无 SELECTMerId,VenderName,ShoppingMonth,TotalOrderNumber,SuccessOrderNumber,TotalPayAmount,SuccessTotalPayAmount, CASE TotalOrderNumber WHEN 0 THEN '0%' ELSE CONVERT(varchar,CONVERT(DECIMAL(10,2),CONVERT(DECIMAL(16,2), SuccessOrd

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
统计百分比
Kenyataan:
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn