救急！我被这个逻辑弄晕了！！SQL语句

[编程有钱人了]

就一个表
3个字段

ID 自增的
UserName 用户名
Tjr 推荐人

例如：
ID UserName Tjr
1 wang 11
2 a wang
3 b wang
4 zhangsan 22
5 c zhangsan
6 d zhangsan
7 lisi 33
8 e lisi
9 f lisi
10 kkk wang


现在要筛选出 推荐出2个人的用户
比如“wang” 推荐了"a","b" 2个或2个以上就符合
zhangsan 推荐了“c”，“d” 也符合标准
a 不符合 ，因为他一个人都没推荐，同样b 也不符合


筛选出这样的用户要怎么写SQL？我晕了

[打一壶酱油]

select b.*
from (select Tjr from tab group by Tjr having count(1)>1)a
inner join Tjr as b on a.Tjr=b.Tjr

[中国风]

select Tjr from tab group by Tjr having count(1)>1

[中国风]

count(1)<2--反之可改為

[王向飞]

select Tjr ,count(Tjr)
FROM [TB]
group by Tjr
having count( Tjr)>=2

[编程有钱人了]

[Quote=引用 1 楼 roy_88 的回复:]

select Tjr from tab group by Tjr having count(1)>1
[/Quote]
我要的是UserName

[快溜]

select * from tb 
where username in (select Tjr from tb group by Tjr having count(1)>1)

[快溜]

[Quote=引用 4 楼 wangjun8868 的回复:]
引用 1 楼 roy_88 的回复:

select Tjr from tab group by Tjr having count(1)>1

我要的是UserName
[/Quote]

select username from tb
where username in (select Tjr from tb group by Tjr having count(1)>1)

[编程有钱人了]

大家说的都对！！！

[叶子]

declare @table table (ID int,UserName varchar(8),Tjr varchar(8))
insert into @table
select 1,'wang','11' union all
select 2,'a','wang' union all
select 3,'b','wang' union all
select 4,'zhangsan','22' union all
select 5,'c','zhangsan' union all
select 6,'d','zhangsan' union all
select 7,'lisi','33' union all
select 8,'e','lisi' union all
select 9,'f','lisi' union all
select 10,'kkk','wang'

select Tjr from @table group by Tjr having (count(1)>1)
/*
Tjr
--------
lisi
wang
zhangsan
*/

[中国风]

[Quote=引用 4 楼 wangjun8868 的回复:]

引用 1 楼 roy_88 的回复:

select Tjr from tab group by Tjr having count(1)>1

我要的是UserName
[/Quote]

select
b.*
from (select Tjr from tab group by Tjr having count(1)>1)a
inner join Tjr as b on a.Tjr=b.Tjr