gistfile1.txt select format(sum(totalAmount),2) as amount from template_order where memberDeleted = 0 and adminDeleted = 0 and storeId = ?说明:使用format(x,y)函数格式化小数,x表示字段名,y表示需要保留的小数位数
select format(sum(totalAmount),2) as amount from template_order where memberDeleted = 0 and adminDeleted = 0 and storeId = ? 说明:使用format(x,y)函数格式化小数,x表示字段名,y表示需要保留的小数位数