使用PHP和Mysql
我的表(产品)中的字段为id
、full_price
、sell_price
等。
如何选择产品按折扣DESC订购,其中折扣=(full_price-sell_price)*100/full_price?我试着使用这个,但它不起作用:
SELECT *
FROM product
WHERE full_price > 0
ORDER BY (discount = (full_price - sell_price) * 100 / full_price)
LIMIT 10
如果您希望折扣也成为结果集中的一列,请这样做:
SELECT *, (full_price - sell_price) * 100 / full_price AS discount
FROM product
WHERE full_price > 0
ORDER BY discount DESC
还没有尝试过。但请尝试
SELECT * FROM product
WHERE full_price>0
ORDER BY (full_price-sell_price)*100/full_price LIMIT 10