I want to round off the sum to one decimal i'm trying this below
round(sum(cast(expend as float)/1000),1) AS "ROUNDING TO ONE DECI"
It says as function round(double precision, integer) does not exist
Please can anyone say about this
Asked
Active
Viewed 2,645 times
3
-
https://stackoverflow.com/a/13113623/5110151 – oguzhan00 Jul 25 '17 at 06:44
-
Datatype should be `numeric` in PostgreSQL – boop_the_snoot Jul 25 '17 at 06:45
-
or this [Stackoverflow answer](https://stackoverflow.com/questions/10380197/sql-rounding-off-to-2-decimal-places) – Fmanin Jul 25 '17 at 06:45
-
I don't know who closed this.. this question is not answered anywhere in the above link. The question is to round a return value from sum() function. You can;t apply above solutions, it gives nested function call not allowed error. – sarath Aug 25 '20 at 19:17