Skip to content
Advertisement

Filter out specific value without excluding the NULL rows

I have the following table and I want to filter out a specific value but keeping the null (empty) rows.

I tried different ways but the query kept filtering out the null rows. For example, I only want to filter out the rows with the orange, the output table should be:

I also tried with

OR

All of the returned results exclude the rows with the null value. Any suggestions would be really appreciated.

Advertisement

Answer

If you have this schema:

You could use:

Which results in:

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement