例子:
create table Student
(StudentID char(10),
Name char(10))
找出出现两次以上的名字
select Name
from Student
group by Name
having count (distinct StudentID) >= 2
select Name
from Student
group by Name
having count (distinct StudentID) >= 2