MySQL分页和排序

排序：升序ASC 降序DESC，以升序为例：

1 select s.studentNo,studentName,subjectName,studentGrades
2 from student as s             --as可以省略
3 inner join grades as g
4 on s.studentNo=g.studentNo
5 inner join subject  as sub
6 on g.subjectNo=sub.subjectNo
7 where subjectName=`数据库结构-1`  
8 order by studentGradesASC

分页：limit语句，记住limit是放在最后

limit 起始值，每页显示几条数据。limit 0,5------1~5     limit 1,5------2~6   .....    limit  (n-1)*pagesize,pagesize

1  select s.studentNo,studentName,subjectName,studentGrades
2  from student as s            
3  inner join grades as g
4  on s.studentNo=g.studentNo
5  inner join subject  as sub
6  on g.subjectNo=sub.subjectNo
7  where subjectName=`数据库结构-1`  
8  order by studentGrades ASC
9  limit 0,5   --第一页