如何查询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 distinct biao.id

from biao

left outer join (select col1, col2

from biao

group by col1, col2

having count(*) >1) tmp

on biao.col1 = tmp.col1

and biao.col2 = tmp.col2

查看可用如下方法：

1、创建测试表，插入数据：

1

2

3

4

5

6

7

8

9

10

11

12

13

create table product

(id int,

name varchar(10),

totol int)

insert into product values (1,'香蕉',100)

insert into product values (2,'橘子',67)

insert into product values (3,'葡萄',89)

insert into product values (4,'苹果',235)

insert into product values (5,'香蕉',77)

insert into product values (6,'芒果',34)

insert into product values (7,'葡萄',78)

insert into product values (8,'梨',24)

表中数据如：

2、如果查询name列有重复的数据，可执行sql语句：

1

select * from product where name in (select name from product group by name having COUNT(*)>1)

说明：查询的结果就是香蕉和葡萄在表中是有重复的

---