You are viewing a single comment's thread. Return to all comments →
Hi, could anyone please point out the mistake in my query wriiten below. I am not able to figure out why it says wrong answer!
select case when A+B <=C OR B+C <=A OR C+A <=B then 'not a triangle'
when A=B and B=C and C=A then 'Equilateral triangle'
when A=B or B=C or C=A then 'Isosceles triangle'
else 'Scalene triangle'
Thank you for replying. Although, I did try that too. It did not work.
The sql query conditions are correct.The statements in the then of sql case should be modified.Change 'Equilateral triangle' to 'Equilateral' and do other changes as below.
when A+B <=C OR B+C <=A OR C+A <=B then 'Not A Triangle'
when A=B and B=C and C=A then 'Equilateral'
when A=B or B=C or C=A then 'Isosceles'
Your Query is Correct but the output should match with question
'not a triangle' -> "Not A Triangle"
'Equilateral triangle' -> "Equilateral"
'Isosceles triangle' -> "Isosceles"
'Scalene triangle' -> "Scalene"