子查询:
(下面的例子中cat_id表示栏目,goods_name表示商品名字,shop_price表示商品价格)
一、where型子查询:把内层查询的结果作为外层查询的比较条件
例:
1、selectgoods_id,goods_name from goods where goods_id = (select max(goods_id) fromgoods);
2、查出每个栏目下最新的商品(以goods_id最大为最新)
select goods_id,cat_id,goods_name fromgoods where goods_id in (select max(goods_id) from goods group by cat_id);
//此句相当于先按cat_id分组查询出每个栏目最新的所有good_id