I have a table

create table us
(
 a number
);

Now I have data like:

a
1
2
3
4
null
null
null
8
9

Now I need a single query to count null and not null values in column a

26 Answers
26

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *