-- 查询最高和最低年龄 SELECT MAX(age) AS max_age, MIN(age) AS min_age FROM users; -- 查询最大订单金额 SELECT MAX(amount) AS max_order FROM orders; -- 每个分类的最高和最低价格 SELECT category, MAX(price) AS max_price, MIN(price)
-- 查询最高和最低年龄 SELECT MAX(age) AS max_age, MIN(age) AS min_age FROM users; -- 查询最大订单金额 SELECT MAX(amount) AS max_order FROM orders; -- 每个分类的最高和最低价格 SELECT category, MAX(price) AS max_price, MIN(price)