在MSSQL,我想删除表的某些行?

有一个表有100000行数据,我想删除前面的8000行,我应该怎样写指令啊.
ID号是从1到10000的.

补充：是 between 1 to 5000 还是 between 1 and 5000 啊？不记得啦。。。。

答案：这些基础性的问题用得着这么高分不？？

我也已经回答了！

delete from 表 where id between 1 to 5000 

或者是 


delete from 表 where id>=1 and id<=5000 


共同学习！

Q:834331524

验证信息：数据库

其他：delete from 表 where id between 1 and 8000
刚才我不是回答过了吗?一样的道理
不好意呀 直接用delete from table where id<=8000就行了 alter table 表名
delete where id<=1001 delete from 表 where id between 1 and 8000 回答过了的!!!!

是这个: 
delete from 表名 where id between 1 and 5000 

绝对不是between 1 to 5000 

我已经实践过了!!!!

上一个：ASP+MSSQL的问题，高手进
下一个：MSSQL如果删除表中的一部分行?