34,576
社区成员
发帖
与我相关
我的任务
分享
create table tc
(id int,
uname char(1) ,
trade varchar(10)
)
insert into tc select
1, 'a', '1,5,25'
insert into tc select
2, 'b', '2,5'
insert into tc select
3, 'c', '6'
select a.uname a,b.uname b
from tc a,tc b
where a.trade like N'%5%'
and b.trade like N'%5%'
and a.id<>b.id