We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
INITIALLY I USED
SELECT
CASE
WHEN (A + B <= C) OR (B+C<= A) OR (A+C<= B) THEN "Not a Triangle"
ELSE #THEN WE CHECK THE MOST specific one
CASE
WHEN A = B AND B = C THEN "Equilateral"
WHEN A = B OR B = C OR A = C THEN "Isosceles"
ELSE "Scalene"
END
END AS TYPE
BUT IT DIDNT WORK, SO I SWICHED TO
SELECT CASE
WHEN A + B > C AND B + C > A AND A + C > B THEN
CASE
WHEN A = B AND B = C THEN 'Equilateral'
WHEN A = B OR B = C OR A = C THEN 'Isosceles'
ELSE 'Scalene'
END
ELSE 'Not A Triangle'
END
FROM TRIANGLES;
apart from the fact that i started with the true instead of the false this time i dont get why the first one did not work
FROM TRIANGLES;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Type of Triangle
You are viewing a single comment's thread. Return to all comments →
INITIALLY I USED SELECT CASE WHEN (A + B <= C) OR (B+C<= A) OR (A+C<= B) THEN "Not a Triangle" ELSE #THEN WE CHECK THE MOST specific one CASE WHEN A = B AND B = C THEN "Equilateral" WHEN A = B OR B = C OR A = C THEN "Isosceles" ELSE "Scalene" END END AS TYPE BUT IT DIDNT WORK, SO I SWICHED TO
SELECT CASE
WHEN A + B > C AND B + C > A AND A + C > B THEN CASE WHEN A = B AND B = C THEN 'Equilateral' WHEN A = B OR B = C OR A = C THEN 'Isosceles' ELSE 'Scalene' END ELSE 'Not A Triangle' END FROM TRIANGLES;
apart from the fact that i started with the true instead of the false this time i dont get why the first one did not work
FROM TRIANGLES;