round (字段名,2)
例:
select org_name,
round (consume_price,2) as consume_price ,
round (consume_num,2) as consume_num from 表名
round (字段名,2)
例:
select org_name,
round (consume_price,2) as consume_price ,
round (consume_num,2) as consume_num from 表名