[Solved] Remove Decimal places or Round to 2 Decimal places in SQL Server Query

You can use below Query

SQL

DECLARE @Num1 NUMERIC(10, 2), @Num2 NUMERIC(10, 2)
DECLARE @Result NUMERIC(10,2)
SET @Num1 = 83
SET @Num2 = 17
SET @Result = @Num1/@Num2
SELECT @Result 
SELECT FLOOR(@Result)
SELECT ROUND (@Result,1)

Output:

4.88 rounded to 4 or 4.90