请问如何判重？

[NewSun99]

表：
ID（PK），COL1，COL2，...,COLN
如何判断非关键字字段是否重复?

[dotnba]

select A.*
from Table A,
(select B.col1,B.col2,...,B.coln from table B group by B.col1,B.col2,...,B.coln having count(1) > 1) C
where A.Col1 = C.Col1 and A.Col2 = C.Col2 and ....A.ColN = C.ColN

[bomber2001]

select A.*
from Table A,
where A.Col1 = C.Col1 or A.Col2 = C.Col2 or ....A.ColN = C.ColN

[dotnba]

select A.*
from Table A
where
(select count(1)
from Table C
where A.Col1 = C.Col1 and A.Col2 = C.Col2 and ....A.ColN = C.ColN) > 1

[sunbird810]

用FIND函数查找

[prain2003]

不知道你是检查已有的数据
还是在插入时判断
插入时，可以建一个唯一索引

[ice2water]

select * from table1 group by col_22 having count(*) >1;

[mengfan8868]

提醒一下,要分两种情况:
(1)在数据库中提取
(2)在数据窗口或是数据存储的三个缓冲区中

[NewSun99]

我就是想知道Sql语句怎么写，与DW无关

[NewSun99]

把所有有重复的都选出来，

[pengdali]

select COL1，COL2，...,COLN from 表 group by COL1，COL2，...,COLN having count(*)>1

[fallstone]

你早把要求写清楚啦。
你卡大力写的，还多了些需求呢