这种情况最好用not in。
not exists可以实现,但不如前者:
select top 20 * from sale as A where not exists
(select * from (select top 10 salenumber from sale) as B
where salenumber = A.salenumber)
not exists可以实现,但不如前者:
select top 20 * from sale as A where not exists
(select * from (select top 10 salenumber from sale) as B
where salenumber = A.salenumber)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货