HR-SQL Type of Triangle

1 개요

HR-SQL Type of Triangle

• https://www.hackerrank.com/challenges/what-type-of-triangle/problem

해커랭크 SQL

문제	DB2	MS SQL	MySQL	Oracle
HR-SQL Advanced Select e
HR-SQL Type of Triangle
HR-SQL The PADS
HR-SQL Occupations
HR-SQL Binary Tree Nodes
HR-SQL New Companies

2 DB2

sql

3 MS SQL

sql

4 MySQL

MySQL

Copy

SELECT
CASE
    WHEN A=B AND B=C THEN "Equilateral"
    WHEN A+B <= C THEN "Not A Triangle"
    WHEN B+C <= A THEN "Not A Triangle"
    WHEN C+A <= B THEN "Not A Triangle"
    WHEN A=B AND A<>C THEN "Isosceles"
    WHEN B=C AND B<>A THEN "Isosceles"
    WHEN C=A AND C<>B THEN "Isosceles"
    ELSE "Scalene"
END
FROM TRIANGLES;

5 Oracle

sql

6 같이 보기

• SQL CASE 문