- 博客(11)
- 问答 (3)
- 收藏
- 关注
RSS订阅原创 SQL server查询出只选修两门课程的学生学号和姓名
代码段： SELECT score.SId AS 学号,student.Sname AS 姓名 FROM score LEFT JOIN student ON score.SId=student.SId WHERE score.SId IN (SELECT score.SId FROM score GROUP BY score.SId HAVING COUNT(score.CId)=2 ) GROUP BY score.SId,student.Sname 表： ...
2021-06-06 16:13:48
10692
原创 SQL server查询名字中含有「风」字的学生信息
代码段： SELECT student.SId AS 学号,student.Sname AS 姓名,student.Sage AS 年龄,student.Ssex AS 性别 FROM student WHERE student.Sname LIKE '%风%'
2021-06-06 16:11:42
2740
原创 SQL server查询「李」姓老师的数量
代码段： SELECT COUNT(*) AS '「李」姓老师的数量' FROM teacher WHERE Tname LIKE '李%' SELECT COUNT(*) AS '「李」姓老师的数量' FROM teacher WHERE Tname LIKE '李%' teacher
2021-06-06 16:10:12
4214
原创 SQL server查询和01号的同学学习的课程完全相同的其他同学的信息
代码段： SELECT student.SId AS 学号,student.Sname AS 姓名,student.Sage AS 年龄,student.Ssex AS 性别 FROM student WHERE student.SId<>01 AND student.SId IN (SELECT score.SId FROM score WHERE score.CId IN (SELECT score.CId FROM score WHERE score.SId=01 ) AND NOT
2021-06-06 16:02:52
1129
1
空空如也
SQLserver如何列转行
2021-06-15
SQL server怎么查询本周过生日的学生？
2021-06-07
TA创建的收藏夹 TA关注的收藏夹
TA关注的人