kuang906

  博客园 :: 首页 :: 新随笔 :: 联系 :: 订阅 :: 管理 ::

delete与top连用删除限定的行

delete from Sheet1$ where record_time>'2010-5-5'
delete  tb1 where   [id] in (select top 2 [id]  from tb1)
delete from tb1 where [id] in (select top 5[id] from tb1)

=======================================

Sql2000测试通过

posted on 2012-01-05 23:33  kuang906  阅读(383)  评论(0)    收藏  举报