select sum(receipts_amount)*0.001::numeric as receiptsamount,sum(lp.money))*0.001::numeric as money from lng_purchases
sql合计和除1000保留小数
最新推荐文章于 2022-09-19 23:14:36 发布
select sum(receipts_amount)*0.001::numeric as receiptsamount,sum(lp.money))*0.001::numeric as money from lng_purchases