CODEWITHSUNDEEP
sqlite
leo
leo

Reputation: 224

SQLite select where all columns are not null

I have column1, column2, column3, column4, column5 and so on.

If I know that one column is not null, I can use this query:

SELECT * 
FROM table 
WHERE columnA IS NOT NULL;

But now I want to select rows where all the columns are not null.

How to write is query easily?

Upvotes: 3

Views: 3758

Answers (1)

Zahid Iqbal
Zahid Iqbal

Reputation: 112

Use the query look like this

SELECT * 
FROM table_name
WHERE NOT column1 IS NULL AND NOT column2 IS NULL...

Upvotes: 6

Related Questions