USE tpch1; select cidx, abs(ROUND(COT(cidx),2)) from datatypetestm order by 1; cidx abs(ROUND(COT(cidx),2)) 1 0.64 2 0.46 3 7.02 4 0.86 5 0.30 6 3.44 7 1.15 8 0.15 9 2.21 10 1.54 11 0.00