sql语句学习 多表连接查询
自己学习的笔记--查询计算机系CS男学生学号、姓名和考试成绩 SELECT A.Sno,A.Sname,B.degree FROM student A,sc B WHERE A.Sdept = 'CS' AND A.Ssex = '男' AND A.Sno = B.sno SELECT A.Sno,A.Sname,B.degree FROM student A INNER JOIN sc B ON A.Sdept = 'CS' AND A.Ssex = '男' AND A.Sno = B.sno
用户评论
thought52941 2020-08-05 07:22:16
实例不错,就是感觉没有优化啊,适合初学者
mikezyc 2020-08-05 07:22:16
这个很强大,全部都是实战!谢谢共享!