日期:2014-05-17  浏览次数:20893 次

求sql,删除 最早日期的一条记录,怎么写
select   *   from   table   order   by   time
查出来的   第一条,删除掉
请指教

------解决方案--------------------
delete from table where time =(select top 1 time from table order by time )
------解决方案--------------------
晕了
delete from table where time in (select min(time) from table)
------解决方案--------------------
delete from table where time in
(
select time from
(
select time from table order by time
)
where rownum = 1
)

------解决方案--------------------
楼上的兄台,如果time是主键那么你的sql没有问题,可是如果不是呢?

改为下面就可以了:

delete from table where rowid in
(
select rowid from
(
select time from table order by time
)
where rownum = 1
);

楼主问题解决了记得给分啊 。