[Leetcode] 610. Triangle Judgement_easy Tag:sql

A pupil Tim gets homework to identify whether three line segments could possibly form a triangle.

However, this assignment is very heavy because there was hundreds of records to calculate.

Could writing a query to judge whether these three sides can form a triangle, assuming table triangle holds t He length of the three sides x, Y and Z.

| X  | y  | z  | | ----|----|----|| 13 | 15 | 30 | | 10 | 20 | 15 |

For the sample data above, your query should return the follow result:

| X  | y  | z  | triangle | | ----|----|----|----------|| 13 | 15 | 30 | No       | | 10 | 20 | 15 | Yes      |

Code

1) Use IF

SELECT * ,  (x+y> and x+z> and y+Z >  as Triangle  from Triangle

2) Use case

SELECTx, Y, Z, Case         whenX+Y>Z andX+Z>Y andY+Z>X Then 'Yes'        ELSE 'No'    END  as 'Triangle' fromTriangle

[Leetcode] 610. Triangle Judgement_easy Tag:sql