这应该也算是穷举法了吧。其他的就想不到了。 with t1 as (select '1265535165656312653126312312' c1 from dual) , t2 as (select rownum rn from dual connect by rownum<=(select length(c1)-2 from t1)) select * from ( select substr(c1, rn, 3) s, count(*) c from t1, t2 group by substr(c1, rn, 3) order by count(*) desc ) aa where rownum=1
with t1 as (select '1265535165656312653126312312' c1 from dual) , t2 as(select substr(c1, level, 3) s, regexp_count(c1, substr(c1, level, 3)) c from t1 connect by level <= length(c1) - 2 order by c desc) select * from t2 where rownum=1;
等大神来吧
with t1 as
(select '1265535165656312653126312312' c1 from dual)
, t2 as
(select rownum rn from dual connect by rownum<=(select length(c1)-2 from t1))
select * from (
select substr(c1, rn, 3) s, count(*) c
from t1, t2
group by substr(c1, rn, 3)
order by count(*) desc
) aa
where rownum=1
(select '1265535165656312653126312312' c1 from dual)
, t2 as(select substr(c1, level, 3) s, regexp_count(c1, substr(c1, level, 3)) c from t1
connect by level <= length(c1) - 2 order by c desc)
select * from t2 where rownum=1;