Oracle DB 11.2.
The table:
ID | PA | PM |
1 | TWO | |
2 | TWO | ONE |
3 | THREE | TWO |
4 | ONE | TWO |
5 | | TWO |
Need to count the values in both PA and PM columns, like
But can do it only for one column, like
WITH T(ID, PA, PM) AS
(
SELECT 1, 'TWO', '' FROM DUAL UNION ALL
SELECT 2, 'TWO', 'ONE' FROM DUAL UNION ALL
SELECT 3, 'THREE', 'TWO' FROM DUAL UNION ALL
SELECT 4, 'ONE', 'TWO' FROM DUAL UNION ALL
SELECT 5, '', 'TWO' FROM DUAL
)
SELECT PA VAL, COUNT(PA) PA FROM T WHERE PA IS NOT NULL
GROUP BY PA
How to add the second column, please?