sql 查询出字符串内有重复字母的

Question

我有一个表，字段 numberName，存的是7位数，如‘1234567’
现在想找出这7位数有重复的，如‘1223456’这样的都查出来，sql语句应该怎么写呢？
sql 2005

Answer 1

--如果是字符型的，用以下语句
SELECT numberName FROM TABLE
WHERE substr(numberName,1,1)=substr(numberName,2,1) OR substr(numberName,1,1)=substr(numberName,3,1) OR substr(numberName,1,1)=substr(numberName,4,1)
OR substr(numberName,5,1)=substr(numberName,6,1) OR substr(numberName,1,1)=substr(numberName,5,1) OR substr(numberName,1,1)=substr(numberName,7,1)
OR substr(numberName,2,1)=substr(numberName,3,1) OR substr(numberName,2,1)=substr(numberName,4,1) OR substr(numberName,2,1)=substr(numberName,5,1)
OR substr(numberName,2,1)=substr(numberName,6,1) OR substr(numberName,2,1)=substr(numberName,7,1) OR substr(numberName,3,1)=substr(numberName,4,1)
OR substr(numberName,3,1)=substr(numberName,5,1) OR substr(numberName,3,1)=substr(numberName,6,1) OR substr(numberName,3,1)=substr(numberName,7,1)
OR substr(numberName,4,1)=substr(numberName,5,1) OR substr(numberName,4,1)=substr(numberName,6,1) OR substr(numberName,4,1)=substr(numberName,7,1)
OR substr(numberName,5,1)=substr(numberName,6,1) OR substr(numberName,5,1)=substr(numberName,7,1) OR substr(numberName,6,1)=substr(numberName,7,1)

--如果是非数值型，在上述字段名前加to_char

Answer 2

select * from 表 where substr(numberName,2,6) like '%'||substr(numberName,1,1)||'%' or
substr(numberName,1,1)||substr(numberName,3,5) like '%'||substr(numberName,2,1)||'%' or
substr(numberName,1,2)||substr(numberName,4,4) like '%'||substr(numberName,3,1)||'%' or
substr(numberName,1,3)||substr(numberName,5,3) like '%'||substr(numberName,4,1)||'%' or
substr(numberName,1,4)||substr(numberName,6,2) like '%'||substr(numberName,5,1)||'%' or
substr(numberName,1,5)||substr(numberName,7,1) like '%'||substr(numberName,6,1)||'%' or
substr(numberName,1,6) like '%'||substr(numberName,7,1)||'%;

Answer 3

selecct * from tableA where numberName like '%11%' or numberName like '%22%' or numberName like '%33%' or..........

这样

Answer 4

什么数据库