-- 按库存升序排序
SELECT * FROM product ORDER BY stock ASC;
-- 查询名称中包含手机的商品信息 按金额降序排序
SELECT * FROM product WHERE NAME LIKE "%手机%" ORDER BY price DESC;
-- 按照金额升序排序,如果金额相同按库存降序排序
SELECT * FROM product ORDER BY price ASC,stock DESC;
mysql单表简单排序查询
最新推荐文章于 2023-10-27 16:50:47 发布