sql - Want decimal result Amazon Redshift

Question

I am trying to calculate the average ice creams a kid will have during summer. I want the result to have 2 decimals. Query:

Select day, (sum(ice_cream_cones) *1.0)/(select count(kids)) 
From t1 Group by 1

The result I get is something like 1.0003. I only want 2 decimal points. Any suggestions?

标签： sqldecimalamazon-redshift

Answer 1

你可以用圆形来做到这一点

Select day, round((sum(ice_cream_cones) *1.0)/(select count(kids) ), 2)
From t1