how to round off value.

Hi Dinesh,

You can use "Round" function to round off the values.

Please refer below example of the rounding.

DECLARE @Num DECIMAL(18,2) = 1.4
SELECT ROUND(@Num,0)

Please let me know if you have any concern or query on this.

Thanks

SELECT ROUND(columnname,0) AS RoundedPrice
FROM tablename;

Usually, rounding is done this way:
1.00 <= X < 1.50 -> 1.00
1.50 <= X < 2.00 -> 2.00

If you don't have a round function, you can round to nearest integer with this formula:
Rounded= Int ( X + 0.5 )

Nearest cent
Rounded= Int ( X * 100 + 0.5 ) / 100

for rounding starting at 0.51:
Rounded= Int ( X + 0.49 )

The round function in modern languages is hiding details, but works the same.