Which of the following is a conditional expression used in SQL?

Question

a) NULLIF

b) WHERE

c) CASE

d) DESCRIBE

Answer 1

The conditional expressions of SQL are mentioned below:

• CASE
• DECODE
• COALESCE
• GREATEST
• IFNULL
• IN
• LEAST

In the options only CASE statement is conditional expression. Hence, option C (CASE) is the correct answer.

Here is the syntax to use the CASE statement:

CASE WHEN condition1 THEN result1

          WHEN condition2 THEN result2

          ……

          ELSE result

END

You can go through SQL tutorial by Intellipaat to learn conditional expressions in SQL.