sql从表中取出31到40条数据
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