Postgresql 如何删除前4条

[云满笔记]

我的数据库表 test 里面有如下条目：

TIME X Y
2013-11-22 16:55:47.509 xx xx
2013-11-22 16:55:47.559 xx xx
2013-11-22 16:55:47.571 xx xx
2013-11-22 16:55:47.582 xx xx
2013-11-22 16:55:47.593 xx xx
2013-11-22 16:55:47.620 xx xx
2013-11-22 16:55:47.631 xx xx
2013-11-22 16:55:47.642 xx xx

如何删除前4条呢，我的意思是按时间排序删除最小的4条。语句越少越简单越好，Postgresql论坛人不多求指教！

[云满笔记]

没有人吗 自己顶个 有没有人来捡分啊

[iihero_]

delete from t where a <= (select max(a) from (select a from t order by a limit 4) BB); a为那时间字段 试试吧

[云满笔记]

引用 2 楼 iihero 的回复:

delete from t where a <= (select max(a) from (select a from t order by a limit 4) BB); a为那时间字段 试试吧

版本很给力!!