mysql-work-master面试题

-- 查询卖的最贵的商品的名称 select goods_name,market_price from ecs_goods where market_price = (select max(market_price) from ecs_goods); -- 查询商品品牌为”仓品”的 所有商品名称和商品价格 SELECT goods_name,market_price FROM ecs_brand RIGHT JOIN ecs_goods ON brand_name = '仓品'; -- 查询商品品牌为”仓品”的 所有商品名称和商品价格 按照价格降序排列 SELECT goods_name,market_price FROM ecs_brand RIGHT JOIN ecs_goods ON brand_name = '仓品' ORDER BY market_price DESC; -- 查询每个商品品牌的商品数量 select GROUP_CONCAT(goods_name),count(*) from ecs_goods GROUP BY brand_id; -- 查询商品品牌对应的商品数量大于5的商品品牌名称 select GROUP_CONCAT(goods_name),count(*) from ecs_goods GROUP BY brand_id having COUNT(*) > 5;