SQL문제풀기

[SQL 문제 풀이] Triangle Judgement (삼각형)

May 19, 2025

[SQL 문제 풀이] Triangle Judgement (삼각형)

Contents

내가 작성한 쿼리

Triangle Judgement - LeetCode

Can you solve this real interview question? Triangle Judgement - Table: Triangle +-------------+------+ | Column Name | Type | +-------------+------+ | x | int | | y | int | | z | int | +-------------+------+ In SQL, (x, y, z) is the primary key column for this table. Each row of this table contains the lengths of three line segments. Report for every three line segments whether they can form a triangle. Return the result table in any order. The result format is in the following example. Example 1: Input: Triangle table: +----+----+----+ | x | y | z | +----+----+----+ | 13 | 15 | 30 | | 10 | 20 | 15 | +----+----+----+ Output: +----+----+----+----------+ | x | y | z | triangle | +----+----+----+----------+ | 13 | 15 | 30 | No | | 10 | 20 | 15 | Yes | +----+----+----+----------+

Triangle Judgement - LeetCode

https://leetcode.com/problems/triangle-judgement/description/

Triangle Judgement - LeetCode

notion image


삼각형을 형성할 수 있는지 여부를 세 개의 선분마다 보고하세요.

결과 테이블을 순서에 상관없이 반환하세요.

내가 작성한 쿼리

MySQL, Oracle


SELECT 
    x,
    y,
    z,
    CASE 
        WHEN x + y > z AND x + z > y AND y + z > x THEN 'Yes'
        ELSE 'No'
    END AS triangle
FROM Triangle;

Share article

Contents

내가 작성한 쿼리