I need to show the data only 2 digits after the decimal point. but when I use select statement, a few have too many digits more than I want. for example, instead of showing 0.6, it appears as
0.59999999999999998
When I look at the data in enterprise manager, it is 0.6
I tried round(num,2) but it did not make any difference.
What can I do to get it right?
Thanks