inblog logo
|
silver
    SQL문제풀기

    [SQL문제풀기] Triangle Judgement

    silver's avatar
    silver
    Nov 08, 2025
    [SQL문제풀기] Triangle Judgement
    Contents
    문제MySQL

    문제

    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/?envType=study-plan-v2&envId=top-sql-50
    Triangle Judgement - LeetCode

    MySQL

    내가 작성한 정답

    select x,y,z ,case when x+y <= z or x+z <= y or y+z <= x then 'No' else 'Yes' end triangle from Triangle;
    Share article

    silver

    RSS·Powered by Inblog