-
Notifications
You must be signed in to change notification settings - Fork 1
/
610_Triangle_Judgement.sql
54 lines (41 loc) · 1.39 KB
/
610_Triangle_Judgement.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
-- Source: https://leetcode.com/problems/triangle-judgement/?envType=study-plan-v2&envId=top-sql-50
-- 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 |
-- +----+----+----+----------+
------------------------------------------------------------------------------
-- SQL Schema
Create table If Not Exists Triangle (x int, y int, z int)
Truncate table Triangle
insert into Triangle (x, y, z) values ('13', '15', '30')
insert into Triangle (x, y, z) values ('10', '20', '15')
-- MS SQL Server Code
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;