IF

Description

The IF function is a conditional judgment function that returns expr1 or expr2 based on the provided conditional expression (cond). When the result of the conditional expression is true, the IF function returns the value of expr1; when the result of the conditional expression is false, it returns the value of expr2.

Parameter Description

• cond (conditional expression): An expression that returns a boolean value (true or false).
• expr1 (expression 1): When cond is true, the IF function returns the value of this expression.
• expr2 (expression 2): When cond is false, the IF function returns the value of this expression.

Return Result

The return type of the IF function is the same as the type of expr1 and expr2.

Example

1. Example 1: Compare values and return results

SELECT IF(a > 10, 'Greater than 10', 'Less than or equal to 10') AS result FROM VALUES(5), (15), (10) AS t(a);

 result    
+-----------+
 Less than or equal to 10 
 Greater than 10     
 Less than or equal to 10

2. Example 2: Determine if a string is empty

SELECT IF(name = '', 'Empty String', 'Non-Empty String') AS result FROM VALUES('张三'), (''), ('李四') AS t(name);
result
+-----------+
Non-Empty String
Empty String
Non-Empty String

3. Example 4: Determine Grade Based on Score

SELECT IF(score >= 90, '优秀', IF(score >= 60, '及格', '不及格')) AS grade FROM VALUES(85), (95), (55) AS t(score);
grade
+-----------+
及格
优秀
不及格