Sort by

recency

|

3370 Discussions

|

  • + 1 comment

    in MySQL:

    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 TriangleType FROM TRIANGLES;

  • + 0 comments

    Oracle:

    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 a = c OR b = c THEN 'Isosceles' ELSE 'Scalene' END AS TriangleType FROM triangles ;

  • + 0 comments

    select case when ((A+B)<=C) or ((B+C)<=A) or ((C+A)<=B) then "Not A Triangle" when (A=B and B=C) then "Equilateral" when (A!=B and B!=C and A!=C) then "Scalene" when (A=B or B=C or A=C) then "Isosceles" end as Triangle_type from Triangles

    /* "Not A Triangle" condition should be checked first then other conditions, because if its not a valid triangle then there is no point of checking otherconditions */

  • + 0 comments

    For MySQL

    SELECT
        CASE
            WHEN a+b<=c OR b+c<=a OR c+a<=b 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;
    
  • + 0 comments

    MySQL Server:

    select Case when A+B <=C or A+C <=B or C+B <= A then 'Not A Triangle' when (A=B and B = C) then 'Equilateral' when (A=B or B = C or C=A) then 'Isosceles' ELSE 'Scalene' END as triangle_type from triangles;