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.
  1. Prepare
  2. SQL
  3. Advanced Select
  4. Type of Triangle
  5. Discussions

Type of Triangle

Sort by

recency

|

3575 Discussions

|

  • ngochieuledo
     + 0 comments

    i had select all from triangles to check, on the 8 row value is 20 20 40 So, why result on the 8 row is "Not A Triangle"? It's must be Isosceles

  • jr_delaoz
     + 0 comments

    MySQL

    SELECT CASE WHEN (A + B <= C) OR (A + C <= B) OR (C + B <= A) THEN 'Not A Triangle' WHEN (A = B AND A = C) THEN 'Equilateral' WHEN (A = B) OR (A = C) OR (C = B) THEN 'Isosceles' ELSE 'Scalene' END AS triangle_type FROM TRIANGLES;

  • 243rushabh
     + 0 comments
    SELECT 
    CASE 
        WHEN (A + B <= C) OR (A + C <= B) OR (B + C <= A) THEN 'Not A Triangle'
        WHEN A = B AND B = C THEN 'Equilateral'
        WHEN A = B OR B = C OR A = C THEN 'Isosceles'
        ELSE 'Scalene'
    END AS type_of_triangle
FROM TRIANGLES

  • diego_dasp91
     + 0 comments

    If you are asking why the code its wrong. First, check if the triangle exist before the Isosceles condition.

  • knithinkumarred1
     + 0 comments

    SELECT CASE WHEN A + B <= C OR A + C <= B OR B + C <= A THEN 'Not A Triangle' WHEN A = B AND B = C THEN 'Equilateral' WHEN A = B OR B = C OR A = C THEN 'Isosceles' ELSE 'Scalene' END AS TRIANGLE_TYPE FROM TRIANGLES;