怎么提取一个表当中某一字段后5位相同的记录?

[welcomeplay]

怎么提取一个表当中某一字段后5位相同的记录?

[97866]

Select * from TableName where SubString(FieldName,Len(FieldName)-4,5)='55555'

[dafu71]

select * from yourtable where right(rtrim(columnname),5)='yourcondition'

[ljx0486]

select t1.* from tablename t1,tablename t2
where right(rtrim(t1.columnname),5)=right(rtrim(t2.columnname),5)
and t1.columnname <> t1.columnname

[highman]

同意tttzms(网缘)

[erigido]

select * from table where right(rtrim(columnname),5)='12345'

[nboys]

select * from table_name where column1=right(column2,5)

[caiyunxia]

select * from table where right(rtrim(columnname),5)='12345'

[pbsql]

SELECT right(字段,5) from 表 group by right(字段,5)

[tttzms]

select * from <table> where RIGHT(<field>, 5) in (select RIGHT(<field>, 5) from <table> group by RIGHT(<field>, 5) having count(*)>1)

[tttzms]

首先找出相同的5个字的子串.

[hjb111]

select * from table where right(rtrim(columnname),5)='5个字符串'