Home  >  Q&A  >  body text

WHERE columnName IS NULL but not getting expected result

I just started my first project for my portfolio and I'm totally confused...

During the EDA process, I noticed that the Continent column with a NULL value is perfect for queries specifically targeting continents, since the corresponding population column has the total population regardless of date.

So I want to only view the country (location column) by filtering out the NULL values ​​in the continent column:

SELECT 
    *
FROM
    covidDeaths
WHERE continent IS NOT NULL
ORDER BY
    date asc;

However, when I do this, the NULL values ​​still show up in the results table.

P粉509383150P粉509383150370 days ago457

reply all(1)I'll reply

  • P粉130097898

    P粉1300978982023-09-13 21:14:39

    My guess is that these values ​​are not NULL, but empty strings.

    reply
    0
  • Cancelreply