本文展示了一段SQL查询语句，用于获取指定学生的课程列表。通过使用GROUP_CONCAT及GROUP BY函数，实现了按学生ID分组并列出其所有课程的功能。
http://blog.sina.com.cn/s/blog_4e808acf01009qna.html
SELECT student_id, GROUP_CONCAT(courses_id ORDER BY courses_id DESC) AS courses FROM student_courses WHERE student_id=2 GROUP BY student_id;
+------------+---------+
| student_id | courses |
+------------+---------+
| 2 | 5,4,3 |
+------------+---------+
SELECT student_id, GROUP_CONCAT(courses_id ORDER BY courses_id DESC) AS courses FROM student_courses WHERE student_id=2 GROUP BY student_id;
+------------+---------+
| student_id | courses |
+------------+---------+
| 2 | 5,4,3 |
+------------+---------+
扫一扫
7万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
