sql查询

[ghost123cc]

一张表中有id，而且这张表中id 是重复的 ， 在这重复的基础上有不同的值。
写一个sql 查询出来所有id相等的并且重复值大于1的。

[chuanzhang5687]

没看懂

[快溜]

select * from tb group by id having count(*)>1

[gzas1989]

LS正解
对数据分组以后统计~

[wx_1021]

select * from tb group by id >1

凡是大于1的都是多出来重复的

[kaka2010dodo]

[Quote=引用 2 楼 ssp2009 的回复:]

SQL code
select * from tb group by id having count(*)>1
[/Quote]

++

[MOXIE519]

select id from table group by id having count(id)>1

[cn_gaowei]

#创建test表
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`ID` int(11) default '0',
`name` varchar(255) NOT NULL default 'name'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#添加模拟数据
INSERT INTO `test` VALUES (1,'name');
INSERT INTO `test` VALUES (4,'name');
INSERT INTO `test` VALUES (3,'name');
INSERT INTO `test` VALUES (4,'name');
INSERT INTO `test` VALUES (4,'name');
INSERT INTO `test` VALUES (4,'name');
INSERT INTO `test` VALUES (3,'name');
INSERT INTO `test` VALUES (5,'name');
INSERT INTO `test` VALUES (3,'name');
INSERT INTO `test` VALUES (2,'name');
INSERT INTO `test` VALUES (1,'name');
INSERT INTO `test` VALUES (1,'name');

#条件：查询ID重复条数>1的记录
#测试数据有十条，ID只有2和5不满足
#所以应该除了这两条记录都可以查询到
select test.* from test
inner join
(
select ID,count(*) num from test group by ID
) tmp
where test.ID = tmp.ID and tmp.num >1

[xiaojinhua1988]

[Quote=引用 2 楼 ssp2009 的回复:]

SQL code
select * from tb group by id having count(*)>1
[/Quote]
正解

[吾日三省-]

select * from tb group by id having count(*)>1

这个了

[--小F--]

select
 * 
from
 tb 
where
 id 
in 
 (select id from tb group by id having count(1)>1)

[rucypli]

select id
from tb
group by id
having count(*)>1

[THG8888]

select * from tb group by id having count(*)>1 加分了

[dllcash]

select * from table group by id having count(*)>1
重复大于1次的id都会出来