610. Triangle Judgement


Posted by ikl258794613 on 2024-02-26

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

SELECT x ,y ,z ,IF( x+y>z AND x+z>y AND y+z>x , 'Yes','No') AS triangle
FROM Triangle

#SQL







Related Posts

JavaScript 核心 - 物件導向與原型鍊

JavaScript 核心 - 物件導向與原型鍊

CSS 衍生的資安問題(下) - 我愛偷甚麼就偷甚麼

CSS 衍生的資安問題(下) - 我愛偷甚麼就偷甚麼

React hook form(1) - useForm & 它的回傳值(1)

React hook form(1) - useForm & 它的回傳值(1)


Comments