关于找出重复纪录

[Edison621]

数据库表中有纪录完全相同了，怎样找出来？

比如：

id name
--------------
1 zhou
2 wu
2 wu
3 zheng
3 zheng


怎样得到
id name
--------------
2 wu
3 zheng

[daview]

看你的数据库是怎么定义的。如果是以ID为准：

select * from mytable where count(id)>1

如果以name为准，则：

select * from mytable where count(name)>1

如果以name和id为准就麻烦点。

[sandwich1981]

select distinct * from table

[Wonny]

select …… having …… group by ……
自己试试看。

[uuxiaoli]

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

[ziping]

select * from table where id in (select min(id) from table gorup by name)

[yifan600]

select distinct * from mytable where count(id)>1

[daishengs]

select distinct * from mytable where count(id)>1

[zlp321002]

--try

Create table Test(id int,name char(8))
insert into test select 1,'zhou'
union all select 2,'wu'
union all select 2,'wu'
union all select 3,'zheng'
union all select 3,'zheng'

select id,name from test group by id,name having count(id)>1

id name
----------- --------
2 wu
3 zheng

（所影响的行数为 2 行）

[Well]

select * from tablename
where id in
(
select id from tablename
group id
having count(*)>=2
) B