我要删除table表里面ID字段500条数据以后的数据的sql语句怎么写，请教！

Question

如题所述

Answer 1

delete from 表名 where id not in (select top 500 * id from table order by id asc)

select top 500 * id from 表名order by id asc//查询表中钱500数据根据id按升序排列
delete from 表名 where id not in (select top 500 * id from table order by id asc)
就是删除表中不是前500条的数据

Answer 2

delete from table where id>=500;

Answer 3

ID字段500？讲明白点

Answer 4

delete from table where id not in (select top 500 id from table)本回答被提问者采纳