Sort by

recency

|

3491 Discussions

|

  • + 1 comment

    Hi, would could any1 help me out, i came up with this query but somehow it seems to not be correct SELECT CASE WHEN (A = B AND B = C) THEN 'Equilateral' WHEN (A = B OR B = C OR C = A) AND (A <> B OR B <> C OR C <> A) THEN 'Isosceles' WHEN (A <> B AND B <> C AND C <> A) THEN 'Scalene' ELSE 'Not A Triangle' END FROM triangles;

  • + 0 comments

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

  • + 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 Triangle' WHEN A!=B AND A!=C AND B!=C THEN 'Scalene' ELSE 'Isosceles' END AS TRIANGLE_TYPE FROM TRIANGLES; Why It would shows wrong?

  • + 0 comments

    SELECT case when a+b <= c OR b+c <= a OR a+c <= b then 'Not A Triangle' when a = b AND a = c AND b = c then 'Equilateral' when a = b OR a = c OR b = c then 'Isosceles' when a != b AND b != c AND a !=c then 'Scalene' END FROM TRIANGLES;

  • + 1 comment

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

    I dont know why this code is showing error