--显示前条数据
select top(4) * from students;
--pageSize:每页显示的条数
--pageNow:当前页
select top(pageSize) * from students where sno not in (select top(pageSize*(pageNow-1)) sno from students);
--带条件的分页
select top (pageSize) * from studentswhere sno not in(select top(pageSize*(pageNow-1)) snofrom students where ssex='男') and ssex='男';
与Oracle的分页有些大同小异