Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Conditional functions

All about CASE

Report a typo

Select all the correct statements about the CASE statement.

Select one or more options from the list

The CASE statement always has the ELSE part.

CASE returns NULL if there is no ELSE part and conditions aren't met.

If there are a few matches, CASE will return multiple results.

If there are a few matches, CASE will return the first match as a result.

___

Create a free account to access the full topic