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
|
3536 Discussions
|
Please Login in order to post a 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 A=C OR B=C THEN 'Isosceles' ELSE 'Scalene' END FROM TRIANGLES;
what is wrong in the below ?
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