SELECT student.姓名,sc.学号,count() AS COUNT INTO coursecount
FROM sc,student
WHERE sc.学号=student.学号 AND 性别=‘男’
GROUP BY sc.学号,姓名
ORDER BY count() DESC,sc.学号;
插入姓名，学号，课程门数，按课程门数排序，相同课程门数按学排序，写入新表coursecount
最新推荐文章于 2022-03-22 21:08:39 发布
SELECT student.姓名,sc.学号,count() AS COUNT INTO coursecount
FROM sc,student
WHERE sc.学号=student.学号 AND 性别=‘男’
GROUP BY sc.学号,姓名
ORDER BY count() DESC,sc.学号;
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
1395
