SELECT DISTINCT
Runtime,
max(round(zll / 1024, 2)) maxzll
FROM
(
SELECT
concat(
YEAR (Runtime),
'-',
MONTH (Runtime),
'-',
DAY (Runtime),
' ',
CASE HOUR (Runtime)
WHEN LENGTH(HOUR(Runtime)) <> 2 THEN
CONCAT('0',HOUR (Runtime))
ELSE
HOUR (Runtime) END
) AS Runtime,
round(zll/1024,2) as zll
FROM
t_hbyd_yxlb
) t
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货