Java优学网MySQL排序查询入门解析：轻松掌握数据排序技巧，提升查询效率

SELECT * FROM 表名 ORDER BY 字段名;

SELECT student_name, exam_score FROM student_scores ORDER BY exam_score DESC;

SELECT student_name, age FROM students ORDER BY age ASC;

SELECT user_id, username, registration_date, last_login_time FROM users ORDER BY registration_date DESC, last_login_time DESC;

-- 如果我们在(user_id, progress_percentage)上建立索引 SELECT user_id, progress_percentage FROM learning_progress WHERE course_id = 123 ORDER BY progress_percentage DESC;

SELECT course_name, course_status FROM courses ORDER BY FIELD(course_status, '进行中', '即将开始', '已结束');