select from credit where project_id =160990 and PERSON_ID in (select PERSON_ID from (select PERSON_ID ,count(1)from credit where project_id =160990 group by PERSON_ID having count(1)>1)k)
mysql查询指定字段值下重复数据方法
select
*
from
credit
where
project_id
=160990
and
PERSON_ID
in
(
select
PERSON_ID
from
(select
PERSON_ID
,
count(1)
from
credit
where
project_id
=160990
group
by
PERSON_ID
having
count(1)>1)
k)2019-08-05
