select COALESCE(b.price, 0) as price from fruit_sale b
postgresql如果查询出的数据为空,则设为0的方法
最新推荐文章于 2024-07-12 10:47:52 发布
select COALESCE(b.price, 0) as price from fruit_sale b