SQL多字段的查询重复记录
select*from table1 t where (selectcount(*) from table1 where column1=t.column1 AND column2=t.column2 and column3=t.column3)>1
以上是 SQL多字段的查询重复记录 的全部内容, 来源链接: utcz.com/z/531487.html
select*from table1 t where (selectcount(*) from table1 where column1=t.column1 AND column2=t.column2 and column3=t.column3)>1
以上是 SQL多字段的查询重复记录 的全部内容, 来源链接: utcz.com/z/531487.html