Mysql数据库学习

最新推荐文章于 2024-10-28 23:59:14 发布

QiaoJiansen

最新推荐文章于 2024-10-28 23:59:14 发布

阅读量180

点赞数 1

分类专栏： MySQL学习文章标签：数据库 mysql 学习

本文链接：https://blog.csdn.net/qjpa1234/article/details/126924099

版权

MySQL学习专栏收录该内容

4 篇文章 0 订阅

订阅专栏

Mysql数据库学习（三）

第二章：复杂一点的查询

子查询：

嵌套子查询

SELECT product_type, cnt_product
FROM (SELECT *
        FROM (SELECT product_type, 
                      COUNT(*) AS cnt_product
                FROM product 
               GROUP BY product_type) AS productsum
       WHERE cnt_product = 4) AS productsum2;

标量子查询

SELECT product_id,
       product_name,
       sale_price,
       (SELECT AVG(sale_price)
          FROM product) AS avg_price
  FROM product;

关联子查询

SELECT product_type, product_name, sale_price
  FROM product AS p1
 WHERE sale_price > (SELECT AVG(sale_price)
                       FROM product AS p2
                      WHERE p1.product_type = p2.product_type
   GROUP BY product_type);