Question

求个简单的sql数据库记录删除语句

有个sql数据库a，里面的一个表down，我想删除down中第1-1000条数据，sql数据库怎么写？

Answer 1

sql语句：
delete from down where id in(select top 1000 id from down order by id asc)

Answer 2

DELETE FROM DOWN WHERE ID<1001

Answer 3

delete from down where id <1000