查询记录是否重复

[bensontin]

sql = "select * from data where file=value
用这个查询的时候，系统把本记录也算进去了
这样怎么查询都是重复的阿

[学习a123456]

郁闷！

大于1，就说明重复了。等于或者小于1，就说明没有，或者只一条嘛。

[dam520]

select 字段名,count(字段名) as 重复次数 from 表 where 1=1
group by 字段名 having count(字段名)>1

[piperzero]

select articleid,product_id from product where product_id in(select product_id from product group by product_id having count(product_id)>1) order by product_id

[chjpeng]

是做数据更新用吧？id是这条数据的唯一标识
sql = "select * from data where file='" & value & "' and id<>'" & id & "'"

[竹林听雨2005]

select file from data
group by file
having count(*)>1

[竹林听雨2005]

查询记录是否重复。

[bensontin]

顶