34,590
社区成员
发帖
与我相关
我的任务
分享
select distinct sn from scores x
where not exists (select * from scores y where y.sn='4807501')and
not exists(select * from scores z where z.sn=x.sn and z.cn=scores.cn)
select distinct sn from scores x
where not exists (select * from scores y where y.sn='4807501'and
not exists(select * from scores z where z.sn=x.sn and z.cn=scores.cn))