您好,欢迎来到年旅网。
搜索
您的当前位置:首页请使用sql写出每门课成绩前两名的学生姓名及分数

请使用sql写出每门课成绩前两名的学生姓名及分数

来源:年旅网

有三张表,学生表:学号,姓名;课程表:课程号,课程名称;成绩表:学号,课程号,分数;请使用sql写出每门课成绩前两名的学生姓名及分数.

insert into student values
("202202","李四"),
("202203","王五"),
("202204","王二麻子"),
("202205","张敏"),
("202206","张慧"),
("202207","张飞"),
("202208","杨立果"),
("202209","杨三")

insert into curriculum values
("11111","数学"),
("22222","英语"),
("33333","语文"),
("44444","化学"),
("55555","物理"),
("66666","生物"),
("77777","地理")

insert into curriculum values
("202201","11111","66"),
("202201","22222","65"),
("202201","33333","70"),
("202201","44444","77"),
("202201","55555","80"),
("202202","11111","65"),
("202202","22222","70"),
("202202","33333","92"),
("202202","44444","72"),
("202202","55555","67"),
("202203","11111","77"),
("202203","22222","80"),
("202203","33333","75"),
("202203","44444","88"),
("202203","55555",""),
("202204","11111","80"),
("202204","22222","80"),
("202204","33333","67"),
("202204","44444","90"),
("202204","55555","78"),
("202205","11111","98"),
("202205","22222",""),
("202205","33333","80"),
("202205","44444","60"),
("202205","55555","79"),
("202206","11111",""),
("202206","22222","99"),
("202206","33333","87"),
("202206","44444","88"),
("202206","55555","100"),
("202207","11111","80"),
("202207","22222","92"),
("202207","33333","79"),
("202207","44444","93"),
("202207","55555","95"),
("202208","11111","99"),
("202208","22222","87"),
("202208","33333","86"),
("202208","44444","58"),
("202208","55555","98"),
("202209","11111","100"),
("202209","22222","100"),
("202209","33333","90"),
("202209","44444","81"),
("202209","55555","98")

因篇幅问题不能全部显示,请点此查看更多更全内容

Copyright © 2019- oldu.cn 版权所有 浙ICP备2024123271号-1

违法及侵权请联系:TEL:199 1889 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务