sqz_329的博客

原创 DB2 删除重复数据

1.db2 没主键的表2条数据一样怎么删DELETE FROM (select row_number() over(partition by CLO1,COL2,COL3 order by CLO1,COL2,COL3) AS ROW_NO FROM TEST_TAB )WHERE ROW_NO>12.delete from 表名 where 字段=‘日期’ and id not in (select min(ID) from 表名 group by 所有字段 )...