SQL quiz. Given the Users table: <PRE><CODE>| ID | NAME

Given the Users table:

| ID |  NAME      | PASSWORD    | ADDBY  |
------------------------------------------
| EX | IRWANEX    | AB8934B495S |  NULL  |

Will the following query return only one record?

SELECT * FROM USERS WHERE ADDBY = NULL

Explanation

To make it work properly we should use =NULL comparison instead of IS NULL.

WHERE-clause

or Read more about SQL Quizzes