查找表中相同的行

[NHSS2010]

查找表中相同的行

[百年树人]

啥相同？完全相同？

[NHSS2010]

对啊,完全相同的行

[x2593304]

select * from a where id=(select id from a group by id having count(id)>1)
类似这个？ 把所有字段都包扩上 哈哈 有点繁琐 看楼下有啥好办法

[shixixi1987]

select AID,AName from A group by AID,AName having count(AID)>1 and count(AName)>1

[x2593304]

我再来看看美女头像 哈哈

[xman_78tom]

select * from tab
where CHECKSUM(*) in (select CHECKSUM(*) from tab
group by CHECKSUM(*) having COUNT(*)>1);

[htl258_Tony]

--> 生成测试数据表: [tb]
IF OBJECT_ID('[tb]') IS NOT NULL
	DROP TABLE [tb]
GO
CREATE TABLE [tb] ([col] [nvarchar](20))
INSERT INTO [tb]
SELECT 'abc' UNION ALL
SELECT 'abc' UNION ALL
SELECT 'dde' 

;WITH t AS 
(
	SELECT *,cnt=COUNT(1)OVER(PARTITION BY CHECKSUM(*))
	FROM tb
)
SELECT * FROM t 
WHERE cnt>1
/*
col                  cnt
-------------------- -----------
abc                  2
abc                  2

(2 行受影响)
*/

[NHSS2010]

我是用SQL 2000的

[sw138123]

别急，马上解决

[sanshenshi]

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

[好帅的一条鱼]

select   bm   from   sell   group   by   bm   having   count(*)>1