select QueTime,Url,sum(Num) from (SELECT QueTime, SUBSTRING( MAX( CONCAT(LPAD(Num,6,'0'),Url) ), 7) AS Url, 0.00+LEFT( MAX( CONCAT(LPAD(Num,6,'0'),Url) ), 6) AS Num FROM flow where (QueTime >='2005-05-31 20:00:00' AND QueTime <='2005-05-31 24:00:00') GROUP BY QueTime ) as A
group by QueTime,Url
转成MY SQL怎么写?
group by QueTime,Url
转成MY SQL怎么写?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货