1、去重
select * from user a
where a.rowid in (select min(rowid) from user b group by b.name)
去重原理是,先从原表用 group by 根据需要去重的字段分组查询最小的 rowid,组成新表,然后原表根据新表的 rowid 来查询,达到去重目的
2、手机号格式错误过滤
select *
from dual a
where regexp_like(a.telephone_no, '^[1][3,4,5,7,8][0-9]{9}$')