第1个回答 2016-08-30
1、有一个函数row_number() over(partition by ID order by message)
2、例如,msg_table,根据message重复值判断是否重复:
delete from msg_table where message_id in (select message_id from (select a.message_id,row_number() over(partition by message order by message) as n from msg_table a where id=20000 ) where n > 1);