[Postgresql] 컬럼을 중심으로 중복되는 행 삭제

■ Example

DELETE FROM message_test
WHERE message_idx IN ( SELECT message_idx
FROM (SELECT message_idx, row_number() over(partition BY user_idx, receiver_idx, message_title ORDER BY message_idx) AS rnum  FROM message_test ORDER BY message_idx DESC) t
WHERE t.rnum > 1);

-> user_idx, receiver_idx, message_title 컬럼의 내용이 동일한 행 삭제