SQL查询　高手看一下内容 - MS-SQL Server / 基础类

数据库里有 uid (身份证号) xmname (项目名称) 两个字段 
库内容如下：

uid xmname

1 xxx
1 YYY
1 ZZZ
2 AAA
2 BBB
3 CCC
4 DDD

我想查询 相同　uid 的　xmname 同时有xxx 和yyy 的人有哪些，，怎么查啊，，　记录出来必须唯一！！！

---

select uid 
from tb t
where xname='xxx' or xname='yyy'
having count(*)>2

---

SQL code:
select uid
from tb t
where xname='xxx' or xname='yyy'
having count(*)>2
group by uid

---

select distinct uid
from tb k  
where exists(select * from tb where k.uid=uid and xmname='XXX')
and exists(select * from tb where k.uid=uid and xmname='YYY')

---

SQL code:


IF object_id('tb')IS NOT NULL DROP TABLE tb
CREATE TABLE tb(uid INT,xmname VARCHAR(5))
INSERT INTO tb
SELECT 1, 'xxx'UNION ALL
SELECT 1 ,'YYY' UNION ALL
SELECT 1 ,'ZZZ'UNION ALL
SELECT 2 ,'AAA'UNION ALL
SELECT 2 ,'BBB'UNION ALL
SELECT 3 ,'CCC'UNION ALL
SELECT 4 ,'DDD'



SELECT * from (
SELECT DISTINCT uid,xmname=stuff((SELECT ','+xmname from tb WHERE uid=a.uid FOR xml path('') ),1,1,'')
from tb a
)c
WHERE charindex('xxx,YYY',xmname)>0

---

引用<