create table #
(
T varchar(10)
)insert into #
select 'A'
union
select 'B'
union
select 'C'
union
select 'D'
union
select 'E'select * from
(select T1.T as T1,T2.T as T2 from
(select * from #) T1,(select * from #) T2) T
where T.T1<>T.T2 and T.T1<T.T2
order by T1
(
T varchar(10)
)insert into #
select 'A'
union
select 'B'
union
select 'C'
union
select 'D'
union
select 'E'select * from
(select T1.T as T1,T2.T as T2 from
(select * from #) T1,(select * from #) T2) T
where T.T1<>T.T2 and T.T1<T.T2
order by T1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货