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?
Use the IS operator
select numbers
from your_table
where numbers is not null and numbers <> ''