if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([A] int,[B] int)
insert [tb]
select 1,1 union all
select 1,2 union all
select 1,3 union all
select 2,1 union all
select 2,2 union all
select 3,3 union all
select 3,4
go

select * from tb t
where not exists(select 1 from tb where a=t.a and b<=2)

/**
A           B
----------- -----------
3           3
3           4

(2 行受影响)
**/

------解决方案--------------------
探讨

select * from tb t
where not exists(select 1 from tb where a=t.a and b<=2)
请教兄台
select 1 from tb where a=t.a and b<=2是什么意思