SQL quiz. Given the Actors table: <pre><code class="sql">+--

Given the Actors table:

+-----------+------+
| Name      | Year |
+-----------+------+
| Nicolas   | 1980 | 
| Leonardo  | 1988 |
| Robert    | 1970 | 
| Adam      | NULL | 
+-----------+------+

How many records will the following query return?

SELECT * FROM Actors
WHERE Year IN (1970,1988,NULL);

Query contains an error and will not be executed
0
1
2
3

Explanation

IS NULL or IS NOT NULL statements should be used to check for null / not null values.
All other types of comparisons (like =NULL, <>NULL, IN (NULL, ...)) are unreliable since they are evaluated to different results in different relational database management systems (False, UNKNOWN)

in-operator

Like

Login in to like
Comment

Login in to comment
Share

Tweet

SQL
Quiz

or Read more about SQL Quizzes

Follow CodeGalaxy

Mobile Beta

Send Feedback