IBM Mainframe Forum

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.

Hi Team,

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

Thanks,
Harish

cross forum post

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