您需要根据自己的要求使用where条件,如下所示:
delete from mytable where id in(1,2,3,4,5,6,7,8,9,10)
或者delete from mytable where id in(select id from mytable where someconditon)
如果您想要使用ctid删除前10个记录,可以尝试以下方法:
DELETE FROM mytable
WHERE ctid IN (
SELECT ctid
FROM mytable
GROUP BY s.serialId, s.valuetimestamp
ORDER BY s.serialId
LIMIT 10
)
如果你想从表格中移除重复项,那么可以尝试以下方法:
DELETE FROM mytable
WHERE ctid NOT IN
(SELECT MAX(s.ctid)
FROM table s
GROUP BY s.serialId, s.valuetimestamp);
DELETE FROM table WHERE table.id IN (SELECT table.id FROM table WHERE *whatever*)