Type of Triangle Hacker Rank Solution

Hello coders, In this post, you will learn how to solve the Type of Triangle Hacker Rank Solution. This problem is a part of the SQL Hacker Rank series.

Type of Triangle Hacker Rank Solution
Type of Triangle Hacker Rank Solution

Problem

Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in the table:

  • Equilateral: It’s a triangle with 3 sides of equal length.
  • Isosceles: It’s a triangle with 2 sides of equal length.
  • Scalene: It’s a triangle with 3 sides of differing lengths.
  • Not A Triangle: The given values of AB, and C don’t form a triangle.

Input Format

The TRIANGLES table is described as follows:

Type of Triangle Hacker Rank Solution

Each row in the table denotes the lengths of each of a triangle’s three sides.

Sample Input

Type of Triangle Hacker Rank Solution

Sample Output

Isosceles
Equilateral
Scalene
Not A Triangle

Type of Triangle Hacker Rank Solution

select if(A+B<=C or B+C<=A or A+C<=B,"Not A Triangle",
if(A=B and B=C,"Equilateral",
if(A=B or B=C or A=C,"Isosceles","Scalene")))
from TRIANGLES as T;

Disclaimer: The above Problem (Type of Triangle) generated by Hackerrank but the Solution is Provided by Chase2Learn. This tutorial is only for Educational and Learning purposes.

Sharing Is Caring

Leave a Comment