CODEWITHSUNDEEP
sqloracle-databaseoracle10g
Dr.Avalanche
Dr.Avalanche

Reputation: 1996

Oracle - SQL - Count multiple fields

Using Oracle 10G

Say for example I have a table with three fields in it, I'd like one query which selects the counts of each column where they are not null. Field name

----------------------------------
| strTest1 | strTest2 | strTest3 |
----------------------------------

I know how to get the count of each one individually:

select count(*) from tablename where strTest1 is not null

but I'd like to know if it's possible to do this within one query for all 3 fields.

Thanks

Upvotes: 0

Views: 7812

Answers (1)

Brian Camire
Brian Camire

Reputation: 4825

It sounds like you want:

SELECT COUNT(STRTEST1), COUNT(STRTEST2), COUNT(STRTEST3) FROM YOUR_TABLE

Upvotes: 5

Related Questions