查最小值简单,
select min(price) from shop where ok=1
如果查小最值对应的id编号或对应字段值是这样的
SELECT id
FROM shop
WHERE price
IN (SELECT MIN(price
) FROM shop
WHERE ok
=1)
查最小值简单,
select min(price) from shop where ok=1
如果查小最值对应的id编号或对应字段值是这样的
SELECT id
FROM shop
WHERE price
IN (SELECT MIN(price
) FROM shop
WHERE ok
=1)