select top 10 * from a where id not in (select top 30 id from a order by id) order by id
关键字:top
reference: http://www.ej38.com/showinfo/sql-113227.html
select top 10 * from a where id not in (select top 30 id from a order by id) order by id
关键字:top
reference: http://www.ej38.com/showinfo/sql-113227.html
转载于:https://www.cnblogs.com/lbsx/archive/2010/02/22/1671072.html