Forum Discussion

JD2021's avatar
JD2021
Copper Contributor
Jul 28, 2021

how insert round function

hi guys,   i am a beginner in SQL . This is my query    This is the result . I want to convert the Annual_premium_In$ to a round figure. How we can do that  Thanks in Advance   ...
Analytics
  • bake13's avatar
    bake13
    Jul 31, 2021

    Hi JD2021 -- The query below will hopefully help you to get started.  Take care.

    SELECT age,nationality,mp,
	convert(float,case
		when mp = 106 then ROUND(MP*12/3.65,2)
		when MP = 79 THEN ROUND(MP*12/3.65,2)
		when MP = 53 THEN ROUND(MP*12/3.65,2)
		when MP = 35 THEN ROUND(MP*12/3.65,2)
	else ROUND(MP/3.65,2)
	end) as Annual_Premium_In$
	FROM metlife..analysis

     

     

     

     

JD2021's avatar
JD2021
Copper Contributor
Jul 30, 2021
where can put the round function on the above mentioned query thanks in advance
bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
Jul 31, 2021

Hi JD2021 -- The query below will hopefully help you to get started.  Take care.

SELECT age,nationality,mp,
	convert(float,case
		when mp = 106 then ROUND(MP*12/3.65,2)
		when MP = 79 THEN ROUND(MP*12/3.65,2)
		when MP = 53 THEN ROUND(MP*12/3.65,2)
		when MP = 35 THEN ROUND(MP*12/3.65,2)
	else ROUND(MP/3.65,2)
	end) as Annual_Premium_In$
	FROM metlife..analysis

 

 

 

 

Resources