先按排序创建视图，语句如下：create view 视图名1 as select ROW_NUMBER() over (order by ⽇期) as num ,* from 表名 go 查询视图，输出结果集如下：通过视图删除前10⾏数据，语句如下：delete from 视图名1 where num <=10;删除表格前1000⾏，把条件改成⼩于等于1000即可 ...