![](https://img-blog.csdnimg.cn/20190918140158853.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
SQL
文章平均质量分 63
1
今天我伏笔了吗
这个作者很懒,什么都没留下…
展开
-
SQL面试必会50题-个人练习总结
1.查询课程编号为“01”的课程比“02”的课程成绩高的所有学生的学号(重点) 关键点-利用子查询构造临时表如下: s_id score(01) score(02) 01 90 80 SELECT a.s_id, s.s_name, a.s_score, b.s_score from (SELECT s_id, s_score from score WHERE c_id='01') as a INNER JOIN (SELECT s_id, s_score from scor原创 2021-09-04 14:35:37 · 203 阅读 · 0 评论 -
Datawhale SQL 04
4.1 UNION ALL 实现不去除重复重复行的并集. SELECT * FROM product WHERE sale_price > 500 UNION ALL SELECT * FROM product2 WHERE sale_price > 500; 4.2 并集-对称差 SELECT * FROM (SELECT * FROM product UNION SELECT * FROM product2) as p WHERE product_id NO原创 2021-08-25 21:53:10 · 95 阅读 · 0 评论 -
Datawhale SQL 03
3.1 CREATE VIEW ViewPractice5_1 AS SELECT product_name,sale_price,regist_date FROM product WHERE sale_price >= 1000 AND regist_date = '2009-09-20' (列名可省略) 结果如下: 3.2 会报错,因为修改视图同样也会修改原表,但表的某些字段不能为空,所以无法插入该条数据。 3.3 标量子查询实现 SELECT product_id, product_原创 2021-08-21 16:39:21 · 114 阅读 · 0 评论