如何查询只有一条记录的人员

[lingshao0909]

表中每个人的记录数不同（1-15条记录），怎么将只有一条记录的人员查询记录查询出来。
表结构：
id mc fx
1 aaa 1
2 ooo 1
3 bbb 1
4 bbb 1
5 ccc 1
6 ddd 1
7 eee 1
8 nnn 1
9 aaa 1
10 aaa 1
11 ccc 1
12 aaa 1
13 aaa 1
14 fff 1
15 aaa 1
16 ggg 1

查询结果
id mc fx
2 ooo 1
6 ddd 1
7 eee 1
8 nnn 1
14 fff 1
16 ggg 1

[dawugui]

select mc from tb group by mc having count(*) = 1

select * from tb where mc in (select mc from tb group by mc having count(*) = 1)

[dawugui]

create table tb(id int, mc varchar(10), fx int)
insert into tb values(1 , 'aaa' , 1 )
insert into tb values(2 , 'ooo' , 1 )
insert into tb values(3 , 'bbb' , 1 )
insert into tb values(4 , 'bbb' , 1) 
insert into tb values(5 , 'ccc' , 1 )
insert into tb values(6 , 'ddd' , 1 )
insert into tb values(7 , 'eee' , 1 )
insert into tb values(8 , 'nnn' , 1 )
insert into tb values(9 , 'aaa' , 1 )
insert into tb values(10, 'aaa' , 1 )
insert into tb values(11, 'ccc' , 1 )
insert into tb values(12, 'aaa' , 1 )
insert into tb values(13, 'aaa' , 1 )
insert into tb values(14, 'fff' , 1 )
insert into tb values(15, 'aaa' , 1 )
insert into tb values(16, 'ggg' , 1 )
go

select mc from tb group by mc having count(*) = 1
/*
mc         
---------- 
ddd
eee
fff
ggg
nnn
ooo

（所影响的行数为 6 行）
*/

select * from tb where mc in (select mc from tb group by mc having count(*) = 1)
/*
id          mc         fx          
----------- ---------- ----------- 
2           ooo        1
6           ddd        1
7           eee        1
8           nnn        1
14          fff        1
16          ggg        1

（所影响的行数为 6 行）
*/
drop table tb