set number of decimal in avg() query

ragonz

how to set the number of decimal when using AVG() query??
for example

select avg(temp) from people group by age;

the result : 23,13214134

i wanna make it into : 23,13

any suggestion??

thx in advance

ragonz

i figured it out already ^^

amitpatel66

Good to hear that you found a solution. It would be great if you can post the solution in this thread so that it wil be helpful for other users who face similar problem.

ragonz

Owh ye, sorry

Just add the round() in ur query

==> select round(avg(temp),x) from people group by age;

'x' is the number of decimal . Hope usefull

Regards

set number of decimal in avg() query

re: set number of decimal in avg() query

re: set number of decimal in avg() query

re: set number of decimal in avg() query

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about