摘要： --查询第八条至第十六条数据--分页 ROW_NUMBER() OVER(ORDER BY orderID DESC) AS 字段编号select title ,UnitPrice from(select title,UnitPrice, ROW_NUMBER() over(order by UnitPrice) as rowNumber from books) tempwhere temp.rowNumber between 1 and 10--页大小 7 第二页: 猪那个问题就是这个问题呗 少了个OrderByselect top 10 title,UnitPrice from books 阅读全文