Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (55.6k points)

a) NULLIF

b) WHERE

c) CASE

d) DESCRIBE

1 Answer

0 votes
by (119k 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

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Mar 23, 2021 in SQL by dev_sk2311 (44.4k points)

Browse Categories

...