Java教程

SQL语句多表查询:显示前5位同学的姓名、课程及成绩

本文主要是介绍SQL语句多表查询:显示前5位同学的姓名、课程及成绩,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
MariaDB [hellodb]> select name,course,score from (select * from students limit 5) as st inner join scores sc on st.stuid=sc.stuid inner join courses co on sc.courseid=co.courseid;
+-------------+----------------+-------+
| name        | course         | score |
+-------------+----------------+-------+
| Shi Zhongyu | Kuihua Baodian |    77 |
| Shi Zhongyu | Weituo Zhang   |    93 |
| Shi Potian  | Kuihua Baodian |    47 |
| Shi Potian  | Daiyu Zanghua  |    97 |
| Xie Yanke   | Kuihua Baodian |    88 |
| Xie Yanke   | Weituo Zhang   |    75 |
| Ding Dian   | Daiyu Zanghua  |    71 |
| Ding Dian   | Kuihua Baodian |    89 |
| Yu Yutong   | Hamo Gong      |    39 |
| Yu Yutong   | Dagou Bangfa   |    63 |
+-------------+----------------+-------+

这篇关于SQL语句多表查询:显示前5位同学的姓名、课程及成绩的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!