SQLize Online / PHPize Online  /  SQLtest Online

create table t ( user_id int, value_1 int, value_2 int ); insert into t values (99, 50, 1), (99, 50, 1), (100, 50, 1), (100, 50, 2), (101, 50, 1), (101, 50, 1), (101, 50, 2), (101, 50, 2), (102, 50, 2), (102, 50, 3); select ctid, * from t; with t1 as( SELECT ctid, user_id, value_1, value_2, ROW_NUMBER () OVER (partition by user_id, value_1 ORDER BY value_2) AS row_num FROM t ) delete from t using t1 where (t.ctid = t1.ctid and t1.row_num > 1); select ctid, * from t;