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>1
2.delete from 表名 where 字段=‘日期’ and id not in (select min(ID) from 表名 group by 所有字段 )
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>1
2.delete from 表名 where 字段=‘日期’ and id not in (select min(ID) from 表名 group by 所有字段 )