0 votes
1 view
in SQL by (36.2k points)

a) NULLIF

b) WHERE

c) CASE

d) DESCRIBE

1 Answer

0 votes
by (86.9k points)

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.

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...