要统计的表示例:
sql如下:
SELECT
COUNT( CASE WHEN STATUS = 1 THEN 1 ELSE NULL END ) AS "已接单",
COUNT( CASE WHEN STATUS = 2 THEN 1 ELSE NULL END ) AS "已装货",
COUNT( CASE WHEN STATUS = 3 THEN 1 ELSE NULL END ) AS "已卸货",
COUNT( CASE WHEN STATUS = 4 THEN 1 ELSE NULL END ) AS "已结算",
COUNT( CASE WHEN STATUS = 5 THEN 1 ELSE NULL END ) AS "已打款"
FROM
tms_order_detail;