Page 1 of 1

SQL AVG function does not return decimal

PostPosted: Fri Nov 19, 2010 12:35 pm
by hnharish
Hi All,

I have written a query to calculate the average value of a column but the issue is the column is not returning Decimal value ex: if the avetrage value is 12.567 its returning the value as 12 i need atleast 2 decimal places to be shown ie. 12.56. Could you pls help me resolving this issue.

Thanks in Advance.

Re: SQL AVG function does not return decimal

PostPosted: Fri Nov 19, 2010 12:38 pm
by hnharish
Hi Team,

Adding to the above queries i m using DB2 SQL query and AVG function to calculate the average.

Thanks,
Harish

Re: SQL AVG function does not return decimal

PostPosted: Fri Nov 19, 2010 1:31 pm
by GuyC
cross forum post

Re: SQL AVG function does not return decimal

PostPosted: Sat Nov 20, 2010 1:06 am
by dick scherrer
Harish,

Do not post topics on multiple forums.

If you would prefer to use this forum instead of the other(s), we can remove you from there.

This topic is now locked.

d