Home mail me! Syndicate this site using RSS

[小技巧]MYSQL中查找重复记录

, , , ,

September 19, 2007 at 17:18:14 · Filed under MySQL

先来录入一些测试数据

CREATE TABLE news(
	ID INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	Title VARCHAR(255) NOT NULL,
	PRIMARY KEY(ID)
);
 
INSERT INTO news (Title) VALUES ('aaa');
INSERT INTO news (Title) VALUES ('aaa');
INSERT INTO news (Title) VALUES ('aaa');
INSERT INTO news (Title) VALUES ('bbb');
INSERT INTO news (Title) VALUES ('bbb');
INSERT INTO news (Title) VALUES ('ccc');

列出所有Title字段重复的记录

SELECT * FROM news WHERE Title IN (
	SELECT Title FROM news GROUP BY Title HAVING (COUNT(*)) >1
)

jimmy said,

April 1, 2009 @ 09:54:52

你好，Justin！我想请教的问题是这条嵌套查询语句SELECT * FROM news WHERE Title IN (
SELECT Title FROM news GROUP BY Title HAVING (COUNT(*)) >1
)可以用联合查询来代替么？

jimmy said,

April 1, 2009 @ 10:08:15

嘿嘿，应是连接查询，对，连接查询。

RSS feed for comments on this post · TrackBack URI

Leave a Comment

*
To prove that you're not a bot, enter this code
Anti-Spam Image