在SQL中，怎么用ROW_Number实现分页？如果我有一个成绩单，我想取出成绩为6-8名的学生，用Row_Number可以实现吗？怎么实现呢

select ROW_NUMBER() over(order by CID) as row_num, * from Classes
执行完上面的sql语句就在表格中添加了名为 row_num 的列，如下图


select * from
(
select ROW_NUMBER() over(order by CID) as row_num, * from Classes
) as t --必须定义子查询后返回的结果集的名称,即t
where t.row_num>=2 and t.row_num<5

下图是最终执行的结果

chenhui 发表于 2012-11-12 15:34
select ROW_NUMBER() over(order by CID) as row_num, * from Classes
执行完上面的sql语句就在表格中添加 ...

懂了，十分感谢ing

不客气，呵呵呵