Skip to content
Advertisement

Code that would show the countries with a greater GDP than any country

I am new to SQL and was trying to solve a question on SQLzoo

Select the code that would show the countries with a greater GDP than any country in Africa (some countries may have NULL gdp values).

My answer to the question was

But the correct answer on the site is

I am not getting why the answer selected by me is wrong

Quiz Question No 5

Advertisement

Answer

The problem with the > all (...) solution selected by you is the fact that some of the gdp values is null.

When you compare a non-null value with a null, then the result is null, unless you use a null-safe operator, such as is null.

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