[Delirium]

Apache Derby doesn't support ROUND function to round off decimal value to some decimal places. Although there is work around for it. You can use this expression to round of value to 2 decimal places: CAST(column + 0.005 AS DECIMAL(15,2)) Simple cast operation just drops the digit. So adding 0.005 in column will have the effect of rounding off.

Взято с http://www.seemoredata.com/en/showth...n-Apache-Derby