Sort by

recency

|

3536 Discussions

|

  • + 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'
            WHEN A != B AND B != C AND A != C THEN 'Scalene'
            ELSE 'Not a Triangle' 
        END
    FROM
        TRIANGLES;
    
  • + 0 comments

    SELECT CASE WHEN (A+B) <= C OR (B+C) <= A OR (A+C) <= B 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 FROM TRIANGLES;

  • + 1 comment
    SELECT
        CASE
            WHEN (A + B <= C) OR (B + C <= A) OR (A + C <= 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 triangle
    FROM TRIANGLES;
    
  • + 1 comment

    what is wrong in the below ?

    select case when a.A = b.A and a.A = b.B and a.A = b.C then 'Equilateral' when a.A = b.A and a.A = b.B and a.A <> b.C then 'Isoceles' when a.A <> b.B and a.B <> b.C and a.A <> b.C and (a.A + b.B) > b.C then 'Scalene' else 'Not A triangle' end as "Triangle Type" from triangles a, triangles b;

  • + 0 comments

    SQL Server Solution-

    SELECT CASE WHEN A + B > C AND B + C > A AND C + A > 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