Relative Content

Tag Archive for sqloraclerounding

ROUND() for decimal places with ZEROs

When I attending a SQL challenge, I am asked to write a query to find average ticket price which is rounded off to 2 decimal places. I got answer as 42.5,55.But the test case is not passed because the answer should be as 42.50,55.00.I used ROUND() ,what is the reason? What I needed to be write there