本文共 483 字,大约阅读时间需要 1 分钟。
最常见的一道SQL数据库面试笔试题,看你是否掌握了?
题目如下:
用一条SQL语句查询出课程表(Course)中每门课(Subject)的分数(Score)都大于80分的学生姓名(Name):Name | Subject | Score |
---|---|---|
Tom | Chinese | 82 |
Tom | Math | 76 |
Jack | Chinese | 75 |
Jack | Math | 92 |
Mary | Chinese | 85 |
Mary | Math | 100 |
Mary | English | 98 |
SQL解答如下:
SELECT Res.NameFROM ( select count( C.Name ) c, C.Name from Course C where C.Score > 80 group by C.Name ) ResWHERE Res.c = ( select count( distinct Subject ) from Course )
转载地址:http://aitlf.baihongyu.com/