好久没写博客了,
delete from t_cont_issue where column_id||','||mutual_table||','||mutual_val in (
select column_id||','||mutual_table||','||mutual_val from t_cont_issue where column_id in (629,630,632,633)group by column_id||','||mutual_table||','||mutual_val
having count(*) > 1)
and rowid not in (select min(rowid) from t_cont_issue where column_id in (629,630,632,633)
group by column_id||','||mutual_table||','||mutual_val
having count(column_id||','||mutual_table||','||mutual_val) > 1)
select * from t_cont_issue where column_id in (629,630,632,633)