select a.NAME,
a.MOUTH,
a.YEAR
from table1
grouby by a.NAME,
a.MOUTH,
a.YEAR
having count(a.NAME)>1
a.MOUTH,
a.YEAR
from table1
grouby by a.NAME,
a.MOUTH,
a.YEAR
having count(a.NAME)>1
调试欢乐多
from 表1
group by name,month,year
having count(*)>1
a.MOUTH,
a.YEAR
from table1 a
group by a.NAME,
a.MOUTH,
a.YEAR
having count(a.NAME)>1
不好意思,上面的那个有点问题