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
|
3343 Discussions
|
Please Login in order to post a comment
My Oracle Solution
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 Triangle_Type FROM TRIANGLES;
Try this
use cursor
select case when A=B and B=C and A=C then "Equilateral" when (A=B or A=C) and B!=C then "Isosceles" when (A+B)>C then "Scalene" when (A+B)