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.
  1. Prepare
  2. SQL
  3. Advanced Select
  4. Type of Triangle
  5. Discussions

Type of Triangle

Sort 1790 Discussions, By:

  • sonukmrhsr1999
     + 0 comments

    select case when a+b<=c or c+b<=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 type_of_circle from triangles;

  • sonukmrhsr1999
     + 0 comments

    select case when a+b<=c or c+b<=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' when a!=b and b!=c then 'Scalene' end as type_of_circle from triangles;

  • george_lazaresc1
     + 1 comment

    Why at row 8 it is expected to be "Not a triangle?" In my case the output for row 8 is 20 20 40

  • fasihhussain00
     + 0 comments
    SELECT 
    CASE 
        WHEN not(A + B > C and B + C > A and A + C > B) THEN 'Not A Triangle'
        WHEN A = B and A = C THEN 'Equilateral'
        WHEN (A = B or B = C or C = A) THEN 'Isosceles'
        ELSE 'Scalene'
    END
FROM TRIANGLES;

  • ahmedneamatalla1
     + 0 comments

    MS SQL SERVER

    SELECT CASE WHEN (A = B AND A = C AND B = C ) THEN 'Equilateral' WHEN (A = B OR A = C OR B = C ) AND (A+B > C) THEN 'Isosceles' WHEN (A != B AND A != C AND B != C ) AND (A+B > C) THEN 'Scalene' ELSE 'Not A Triangle' END AS 'TRIANGLES NAMES' FROM TRIANGLES;

Load more conversations