select *
from (select LLQLX as COUNTTIME,count(*)
as COUNTS ,round(count(*)/(select count(SESSIONID) from
tlink_FWXX where GSID='123'),4)*100 as RATIO from
TLINK_FWXX where GSID='123' and DLSJ between
to_date('2005-4-4','yyyy-mm-dd') and
to_date('2007-4-4','yyyy-mm-dd') group by LLQLX)
group by RATIO,COUNTS这样就可以拉~!
from (select LLQLX as COUNTTIME,count(*)
as COUNTS ,round(count(*)/(select count(SESSIONID) from
tlink_FWXX where GSID='123'),4)*100 as RATIO from
TLINK_FWXX where GSID='123' and DLSJ between
to_date('2005-4-4','yyyy-mm-dd') and
to_date('2007-4-4','yyyy-mm-dd') group by LLQLX)
group by RATIO,COUNTS这样就可以拉~!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货