order by 排序查询 -小林月

 案例：按照学号从小大进行显示名字和班级

SELECT
s_name,s_grade
FROM hel_student_info
ORDER BY s_code

案例二：按照姓名长度进行排序

SELECT
LENGTH(s_name) 姓名长度,s_grade,s_code,s_name
FROM hel_student_info
ORDER BY 姓名长度 ASC;

 案例三：如果按照一个字段排序以后，需要再次排序

#按照学号排序以后再按照姓名排序
SELECT
LENGTH(s_name) 姓名长度,s_grade,s_code,s_name
FROM hel_student_info
ORDER BY 姓名长度 ASC,s_code DESC;