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.
- Prepare
- SQL
- Advanced Select
- Type of Triangle
- Discussions
Type of Triangle
Type of Triangle
Sort by
recency
|
3491 Discussions
|
Please Login in order to post a 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;
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
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?
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;
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