I'm trying to get a value with 1 digit precision when I do the below calculation:
I tried casting the numerator as DECIMAL, but I get a final result with 8 decimal places as shown below.
SELECT (CAST(636 AS DECIMAL(18,2))/80)/3
But I want only 1 decimal place in the result as 2.7
How do I achieve this?