MYSQL学习笔记（七）之子查询（续）

现在计算表中所有商品价格的平均值。

语句:SELECT ROUND(AVG(`goods_price`),2) AS avg_goods_prices  FROM `tdb_goods`;

现在查询价格大于平均值的商品并按商品价格进行降序排列

SELECT `goods_id`,`goods_name`,`goods_price` FROM  `tdb_goods` WHERE `goods_price`>5391.30 ORDER BY `goods_price` DESC;

现在通过子查询一步实现： SELECT goods_id,goods_name,goods_price FROM tdb_goods 

  WHERE goods_price > (SELECT ROUND(AVG(goods_price),2) AS avg_goods_price FROM tdb_goods) 
  ORDER BY goods_price DESC;

查询结果是一样的。