从完整的表中取出的列可当成一个表查看
查询出编号为19的商品的栏目名称(用左连接查询和子查询都可查出)
7.4:用from型子查询把ecs_goods表中的每个栏目下面最新的商品取出来
select * from (select goods_id,cat_id,goods_name from ecs_goods order by goods_id desc) as tmp group by cat_id;
从完整的表中取出的列可当成一个表查看
查询出编号为19的商品的栏目名称(用左连接查询和子查询都可查出)
7.4:用from型子查询把ecs_goods表中的每个栏目下面最新的商品取出来
select * from (select goods_id,cat_id,goods_name from ecs_goods order by goods_id desc) as tmp group by cat_id;