select goods_id,IFNULL(months,0) as months
from goods
where IFNULL(months,0) <= cast('12.0' as decimal(18,1))
sql字符串转换成小数(decimal)
最新推荐文章于 2023-04-26 16:13:41 发布
select goods_id,IFNULL(months,0) as months
from goods
where IFNULL(months,0) <= cast('12.0' as decimal(18,1))