Question

Command used to display all the
rows where the city column is not
empty.
SELECT * FROM dept WHERE city =
O
O
SELECT * FROM depi WHERE city =
'EMPTY
O
SELECT * FROM dept WHERE city IS
NOT NULL;
O
SELECT * FROM dept WHERE city IS
NULL;​

Answer 1

Answer:

SELECT * FROM dept WHERE city IS

SELECT * FROM dept WHERE city ISNULL;