1、重点是要先group by,后hvaing加上条数的限制
select perno from fcperinfo group by perno having count(*) > 1
select perno from fcperinfo where perno in (select perno from fcperinfo group by perno having count(*) > 1)
1、重点是要先group by,后hvaing加上条数的限制
select perno from fcperinfo group by perno having count(*) > 1
select perno from fcperinfo where perno in (select perno from fcperinfo group by perno having count(*) > 1)