这个查询怎么写？？

[bingbing1981]

一个表，两个字段
ID GroupID
001 1
001 2
001 3
002 1
002 2
003 1
. ..

现在想查询出GroupID等于1并且等于2并且等于3的ID是多少
该怎么写

想上面的例子，查出来的结果就是001

[j9898]

select id
from tab
where groupid=1 or groupid=2 or groupid=3
group by id
having count(distinct groupid)=3

[up0point]

select id from tab a
where exists(select 1 from tab where id = a.id and groupid = 1)
and exists(select 1 from tab where id = a.id and groupid = 2)
and exists(select 1 from tab where id = a.id and groupid = 3)

[colinliu]

select id
from tab
where groupid=1 or groupid=2 or groupid=3
group by id
having count(distinct groupid)=3

[qizhanfeng]

select id
from tab
where groupid=1 or groupid=2 or groupid=3
group by id
having count(distinct groupid)=3