Interested to Buy Any Domain ? << Click Here >> for more details...
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);
- 11 Answers
- 15132 Views
- Satyam, I also Faced
- E-Mail Answers
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
Can we create view in stored procedure?
Name the operator which is used in the query for pattern matching?
What is the difference between sql and mysql?
Can we join more than 2 tables in sql?
Which is better join or subquery?
Does asenumerable execute the query?
How many types of functions are there in sql?
Why use truncate instead of delete?
List and explain the different types of join clauses supported in ansi-standard sql?
How to add, remove, modify users using sql?
what is 'mysqlcheck'? : Sql dba
What is the difference between nvl function, ifnull function, and isnull function?
What does the argument [or replace] do?
How many sectors are in a partition?
Does sql use python?
