如何查询mysql数据库中部分重复的数据

你是要查找数据库中某个字段下的相同数据吧，我给你写2个例子

(数据库执行效率高)

select * from dbo.MediafileInfo as a where

(VideoDownUrl IN (SELECT VideoDownUrl FROM MediafileInfo AS B WHERE A.ProgramID <>B.ProgramID))

(数据库执行效率低)

SELECT *

FROM MediafileInfo AS A

WHERE (SELECT COUNT(*) FROM MediafileInfo WHERE VideoDownUrl=A.VideoDownUrl)>1

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)

---