mysql查找最小值对应的记录

Question

列如有表：promotionPrice originalPrice
我要查找promotionPrice促销价最低的促销价和原价信息

Answer 1

你表名没写，我就假定表名为Price

select promotionPrice, originalPrice from Price order by promotionPrice asc limit 1;

也可以这样：

select promotionPrice, originalPrice 
    from Price 
    where promotionPrice = (select min(promotionPrice) from Price);