【练习篇】SQLZOO习题答案_Using Null

最新推荐文章于 2020-12-25 16:42:37 发布

程序媛精灵

最新推荐文章于 2020-12-25 16:42:37 发布

阅读量364

点赞数

分类专栏： SQL_数据库文章标签： sql mysql 数据库

版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文链接：https://blog.csdn.net/weixin_43509575/article/details/109314707

版权

在这里插入图片描述
1.List the teachers who have NULL for their department.

select name from teacher where dept is null

2.Note the INNER JOIN misses the teachers with no department and the departments with no teacher.

SELECT teacher.name, dept.name 
FROM teacher FULL JOIN dept ON (teacher.dept=dept.id)

Use a different JOIN so that all teachers are listed.

SELECT teacher.name,<

最低0.47元/天解锁文章

程序媛精灵

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
【练习篇】SQLZOO习题答案_Using Null

1.List the teachers who have NULL for their department.select name from teacher where dept is null2.Note the INNER JOIN misses the teachers with no department and the departments with no teacher.SELECT teacher.name, dept.name FROM teacher FULL JOIN d.
复制链接

扫一扫

专栏目录

评论

被折叠的条评论为什么被折叠?

到【灌水乐园】发言

查看更多评论

添加红包

成就一亿技术人!

hope_wisdom

发出的红包

实付元

使用余额支付

点击重新获取

扫码支付

钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。