hi How i can avoid the NULL in the result set while using the CASE Statement in ORACLE.
(CASE WHEN (MA.FIELD_NAME = 'UTILITIES_INCLUDED' ) THEN MA.FIELD_VALUE END ) "UTILITIES_INCLUDED",
I suppose to get only one row of data but its bringing two rows but one with NULL.
44 DAVID data Analyst III (null) 1000 7
44 DAVID data Analyst III 1 1000 7
If i remove the CASE Statement from the select query i am getting only one row.
I dont want to add condition in the WHERE Clause because there are other CASE Statements as well. Please help. Thanks.