Wow to use sql to check if there's any value is null

[Patty_Tu]

I'm working on this session, and it shows if I'd like to test NULL value, I'll need to use below syntax:

However, I'd like to know what if I have no idea which column(s) has(have) NULL value?

How should I make a query to look for ANY record that includes NULL value without writing specific column_name?

[Ingolme]

The only way is to do a null test on every column in the table.

SELECT * FROM table_name WHERE column1 IS NULL OR column2 IS NULL OR  column3 IS NULL OR column4 IS NULL

I can't think of any practical use case where I'd want to test for null in all columns.

[Patty_Tu]

But what if there are lots of columns in that table?

I just think it's inefficient to mention every column  under WHERE syntax lol...

Isn't there any other way to test if any row has NULL value?

[Ingolme]

Unfortunately, there is no way to do that in standard SQL, but it really won't take longer than 5 minutes to write the query even if the table has 100 columns.

[Patty_Tu]

7 hours ago, Ingolme said:

y won't take longer than 5 minutes to write the query even if the table has 100

Ok! Thanks for your help!!