Relative Content

Tag Archive for sqlsql-serverdatabaseapache-pinotpinot

how to round of a value to two decimal places

I am using Pinot DB hence STR,FORMAT,CHAR,POSITION,LOCATE and several functions not supported I have a data with 6 to 8 decimal places I want to round it to Millions and display last 2 decimal points in case of less than million value