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