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
- 15242 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
What are sql queries used for?
what is the use of set statement in tsql? : Transact sql
What is output spooling in sql*plus?
How do I turn a list into a table?
Is join same as left join?
What are the types of keys?
What are the uses of sysdate and user keywords?
What do you understand by pl/sql records?
What is the difference between joins?
How delete all records from table in sql?
Can a view be mutating? If yes, then how?
How delete all data from all tables in sql?
What does select count (*) mean in sql?
Which command is used to delete a package?
Why triggers are used?
