接入号最长匹配的两种sql语句,好像速度都一样,查出来的结果可能不一样,都能满足接入号最长匹配的要求
都是oracle的语法。
方法一 :
select
max(length(t.oldaccessno))as accessnolength,
max(t.newaccessno) as newaccessno,
max(t.ACCESSNOPROP) as ACCESSNOPROP,
max(t.oldaccessno) as oldaccessno
from (
select newaccessno , ACCESSNOPROP ,oldaccessno from accessnolist
where
oldaccessno = substr('10676158000000000001',1,length(oldaccessno))
and ACCESSNOPROP ='1') t
方法二 :
select * from (select newaccessno , ACCESSNOPROP ,oldaccessno from accessnolist
where
oldaccessno = substr('10676158000000000001',1,length(oldaccessno))
and ACCESSNOPROP ='1' order by length(oldaccessno) desc ) where rownum =1