anjum anjum - 5 months ago 32
SQL Question

Select rows where column is null

How do you write a SELECT statement that only returns rows where the value for a certain column is null?

Answer

Do you mean something like:

SELECT COLUMN1, COLUMN2 FROM MY_TABLE WHERE COLUMN1 = 'Value' OR COLUMN1 IS NULL

?