how to eliminate null values in a column i.e
table vlaues
1 2 3
NULL 3 4
1 5 NULL
i want output like this
1 2 3
3 4
1 5
i dnt want to use nvl is null and i dnt want replace the
NULL value with any value i.e nvl(col,o);
Answer Posted / chandra shekhar
Dear Lavanya,
You cannot equate the NULL with the operators like = and !=
NULLs can be equated with "IS NULL" or "IS NOT NULL"
(Double quotes " not included)
In u r query if u say IS NOT NULL, then also as per question asked in the very beginning it will not suffice.
As there are multiple columns with multiple NULLs in all the given columns .
Regards
J
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the various restrictions imposed on view in terms of dml?
What are the types of optimization?
What is sql basics?
Do we need to create index on primary key?
What is a constraint? Tell me about its various levels.
Can ddl statements be used in pl/sql?
Explian rowid, rownum? What are the psoducolumns we have?
Can you have more than one trigger on a table?
What is the difference between rename and alias?
Can we call stored procedure in function?
What is exit statement?
how to drop an existing table in mysql? : Sql dba
what is a composite key ? : Sql dba
what is subquery? : Sql dba
What is normalization? How many normalization forms are there?