过滤不等于空条目

Question

I have a column, which stores numbers with null permitted .

A sample entry in column numbers:

numbers :
123
null
null
546
null

How do I extract non-null entries in SQL?

Answer 1

Use the IS operator

select numbers 
from your_table
where numbers is not null and numbers <> ''