mysql--（入门语句17--where型子查询）

子查询：
#where型子查询
#from型子查询

#exit型子查询

#where子查询：

是指把内层查询的结果作为外层查询的比较条件

#where子查询
#要求查询出最新的商品（以id最大为最新）
1.select goods_id,goods_name from goods order by goods_id desc limit 1;
2.#不用order by的时候：
select goods_id,goods_name from goods where goods_id=33;//（预先知道id，随着数据变化，不能及时更新）
3.select max(goods_id) from goods;
4.select goods_id,goods_name from goods where goods_id =(select max(goods_id) from goods);//最终实现

#用where型的子查询，查出每个栏目下最新（以id最大为最新）的商品：
1.select cat_id,max(goods_id) from goods group by cat_id;
2.select goods_id,cat_id,goods_name  from goods where goods_id in(select max(goods_id) from goods group by cat_id);

#用where型的子查询，查出每个栏目下最贵的商品：
select goods_id,goods_name,cat_id,shop_price from goods where shop_price in (select max(shop_price) from goods group by cat_id);