题解 | 找到特殊的电话号码
找到特殊的电话号码
https://www.nowcoder.com/practice/cfb479bf0f5f4251afc536ddb12d1f32
select distinct 电话号码 from 电话费用表 where 月份 between '201701' and '201710' and( substr(电话号码,-4) regexp "([0-9])\\1([0-9])\\2" or substr(电话号码,-4) regexp "([0-9])([0-9])\\1\\2" or substr(电话号码,-4) regexp "([0-9])\\1\\1\\1\\1" )
查看9道真题和解析
