求一SQL语句 ( 积分: 50 )

select sno,city from S Group by sno,city having count (distinct city)>2

s1 沈阳
s2 北京
s3 北京
s4 沈阳
s5 哈尔滨
s6 北京
得到结果
s1 沈阳
s2 北京
s3 北京
s4 沈阳
s6 北京
要求两个或两个以上供应商所在城市相同

不会吧沉那么快。 没人会吗？

Select * From S(NOLOCK) where sno in(
(Select sno From S(NOLOCK) Group By sno Having Count(sno)=2))

select sno,city from S where sno in (Select sno From S(NOLOCK) Group By sno Having Count(sno)>=2)

接受答案了.