SELECT COUNT (*) 单数, TO_CHAR (creattime, 'yyyy-mm-dd') 时间,
SUM (CASE
WHEN = 2
THEN 1
ELSE 0
END) 正常,
SUM (CASE
WHEN = 0
THEN 1
ELSE 0
END) 延迟,
SUM (CASE
WHEN = 1
THEN 1
ELSE 0
END) 提前
FROM network_checkin
WHERE TO_CHAR (creattime, 'yyyy-mm-dd') > '2014-11-25 15:53:11'
GROUP BY TO_CHAR (creattime, 'yyyy-mm-dd')
ORDER BY TO_CHAR (creattime, 'yyyy-mm-dd')
SUM (CASE
WHEN = 2
THEN 1
ELSE 0
END) 正常,
SUM (CASE
WHEN = 0
THEN 1
ELSE 0
END) 延迟,
SUM (CASE
WHEN = 1
THEN 1
ELSE 0
END) 提前
FROM network_checkin
WHERE TO_CHAR (creattime, 'yyyy-mm-dd') > '2014-11-25 15:53:11'
GROUP BY TO_CHAR (creattime, 'yyyy-mm-dd')
ORDER BY TO_CHAR (creattime, 'yyyy-mm-dd')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货