当然当然是
select top 20 B7 from TABLE where ID not in --not in
(select top 20 ID from TABLE where B7='4' --等于4
and ID2 in(74,75)
order by B7 Desc) order by B7 Desc
select top 20 B7 from TABLE where ID not in --not in
(select top 20 ID from TABLE where B7='4' --等于4
and ID2 in(74,75)
order by B7 Desc) order by B7 Desc
select top 20 b7 from [table] where b7<>'4' --and id2 in (74,75)
order by b7 desc --这样就行了吧,但不是随机的select top 20 b7 from [table] where b7<>'4' --and id2 in (74,75)
order by newid() --随机