Question

select Student.Sno,Sname,Ssex,Cname,Grade from Student,SC,Course where Student.Sno=SC.Sno and SC.Cno

order by Student.Sno 用sql server对上述结果做分页显示，我以前没学过对分页不了解，求高手指点

Answer 1

order by Student.Sno表示的是对查询的出来的结果以Student.Sno字段排序，默认为升序