select a.callednumber,b.fee,a.asd from
(select callednumber,nvl(max(areacode),decode(substr(callednumber,1,1),'0',decode(substr(callednumber,2,1),'0','00*','0*'),'local*')) as asd from (select * from payrate where group='2') payrate,cdrinfo where cdrinfo.callednumber like payrate.areacode(+)||'%' group by cdrinfo.callednumber) a, payrate b
where a.asd=b.areacode and b.group='2'
(select callednumber,nvl(max(areacode),decode(substr(callednumber,1,1),'0',decode(substr(callednumber,2,1),'0','00*','0*'),'local*')) as asd from (select * from payrate where group='2') payrate,cdrinfo where cdrinfo.callednumber like payrate.areacode(+)||'%' group by cdrinfo.callednumber) a, payrate b
where a.asd=b.areacode and b.group='2'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货