where 子查询
五种子句是有 严格的顺序的 where,group by,having,order by,limit
查询每个栏目中最新的产品
所有的商品 是一个大块 每个栏目 即按栏目分
每个栏目中 还要找出 各自的小块 即 每个栏目中 goods_id 最大的商品 所以叫做 子查询
select goods_id,goods_name from goods where goods_id=(select max(goods_id) from goods);
类比:
select cat_id,max(goods_id) from goods group by cat_id;
select goods_id,goods_name from goods where goods_id in (select max(goods_id) from goods group by cat_id);
select goods_id,cat_id,goods_name from goods where goods_id in (select max(goods_id) from goods group by cat_id);
注意:
在子查询的SELECT 后面仅指定一个需要比较的字段即可
否则: