select COALESCE(b.price, 0) as price from fruit_sale b
postgresql如果查询出的数据为空,则设为0的方法
最新推荐文章于 2024-06-04 11:38:19 发布
select COALESCE(b.price, 0) as price from fruit_sale b