DB ESE
SELECT AVG(COLUMN)
FROM TABLE

i have this query. i have assigned column with datatype decimal(9,2). but when it produces result, it has a lot of decimal places. i tried rounding but it gives unnecessary zeros and doesn't even follow the 2 decimal places. i've read about formatting.. i tried them but doesn't work.. i should be missing something! pls help!

SELECT cast(AVG(salary) as decimal(9,2)) FROM emp

oic.. now, i understand! tnx a lot