如何用SQL语句删除一个表中按时间字段排序的前N条记录(50分)

我行我酷 · 2006-09-25

如何用SQL语句删除一个表中按时间字段排序的前N条记录

yuzk2005 · 2006-09-25

delete top

from table order by datefield

我行我酷 · 2006-09-25

不行啊,这个试过了...

hhjjhhjj · 2006-09-25

order by datefield desc?

breezee · 2006-09-25

delete table1
where datafield<=(select top 1 datefield from (select top n datefield from table1 order by datefield) T order by datefield desc)

Delphistarstar · 2006-09-25

delete from [表A] where idA IN (select top [行数] idA from [表A] order by 时间)
用这个试试

xiexum · 2006-09-25

delete top 100 from table order by yourfield 绝对可以

xiexum · 2006-09-25

delete top 100 from table order by yourfield desc/asc

我行我酷 · 2006-09-25

Delphistarstar提供的答案很不错.简单又明了...

我行我酷 · 2006-09-25

多人接受答案了。