select *from ( select *, row_number() over(order by id desc) as rownum from 表)awhere rownum between 3 and 10 -- rownum between 11 and 20
SQL分页查询
原文：http://www.cnblogs.com/ankeyliu/p/5651108.html
