34,587
社区成员
发帖
与我相关
我的任务
分享
declare @tb table(dd varchar(200))
insert into @tb select 'GCCD006CBC626227003812780056777PS'
insert into @tb select 'GCCD006CBC626227003812780056777UU'
insert into @tb select 'GCCD006CBC626227003819000230555UW'
insert into @tb select 'GCCD006CBC624367423811130846666PS'
insert into @tb select 'GCCD006CBC624367423811130846666aa'
insert into @tb select 'GCCD006CBC624367423811130846666bb'
select * from @tb t where not exists(
select 1 from @tb where left(dd,len(dd)-2)=left(t.dd,len(t.dd)-2) and right(dd,2)<right(t.dd,2))
select dd from A t
where not exists(select 1 from A where substring(dd,31,20)=substring(t.dd,31,20) and right(dd,len(dd)-51)<right(t.dd,len(t.dd)-51))
declare @tb table(dd varchar(200))
insert into @tb select 'GCCD006CBC626227003812780056777PS'
insert into @tb select 'GCCD006CBC626227003812780056777UU'
select * from @tb t where not exists(
select 1 from @tb where left(dd,len(dd)-2)=left(t.dd,len(t.dd)-2) and right(dd,2)<right(t.dd,2))