Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

Special WHERE operators

How to compare?

Report a typo

Which of these statements about operators is correct? Select all of them.

Select one or more options from the list

The IS NOT NULL operator returns TRUE if value is not equal to NULL

The IS NULL operator returns TRUE if value is not equal to NULL

The IS DISTINCT FROM operator acts as the standard equal operator (=) but also returns TRUE if both compared values are NULL

The IS DISTINCT FROM operator acts as the standard not equal operator (!= or <>) but also returns FALSE if both compared values are NULL

___

Create a free account to access the full topic