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