16

dream_py

于 2020-05-27 08:19:51 发布

阅读量164

点赞数

CC 4.0 BY-SA版权

分类专栏：面试题文章标签： sql

本文链接：https://blog.youkuaiyun.com/dream_py/article/details/106372069

面试题专栏收录该内容

37 篇文章

订阅专栏

--  16、检索"01"课程分数小于60，按分数降序排列的学生信息（和34题重复，不重点）
SELECT student.*,score.s_score FROM
student
INNER JOIN
score ON student.s_id=score.s_id
WHERE score.s_score<60 and score.c_id='01'
ORDER BY score.s_score DESC

在这里插入图片描述

--  16、检索"01"课程分数小于60，按分数降序排列的学生信息（和34题重复，不重点）
SELECT student.*,score.s_score FROM
student
INNER JOIN
score ON student.s_id=score.s_id
WHERE score.s_score<60 
GROUP BY score.c_id HAVING score.c_id='01'
ORDER BY score.s_score DESC