SELECT a.* FROM (
SELECT st.s_id,st.s_name,c.c_id,c.c_name,sc.s_score FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
-- 25、查询各科成绩前三名的记录
最新推荐文章于 2022-06-17 08:15:18 发布
SELECT a.* FROM (
SELECT st.s_id,st.s_name,c.c_id,c.c_name,sc.s_score FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id