If Else in Database

Input Format

Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in the table:

The TRIANGLES table is described as follows:

Sample Input

Sample Output

Isosceles

Equilateral

Scalene

Not A Triangle

SOLUTION

SELECT CASE WHEN A+B>C THEN

           CASE WHEN A=B AND B=C AND A=C THEN 'Equilateral'

                WHEN A=B OR B=C OR A=C THEN 'Isosceles'

                WHEN A!=B AND B!=C AND C!=A THEN 'Scalene'

           END

           ELSE 'Not A Triangle'

       END

FROM TRIANGLES;