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
- 14793 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 is not equal in sql?
what is row? : Sql dba
What is integrity in sql?
What is the difference between inner join and left join?
What do you mean by stored procedures? How do we use it?
What will you get by the cursor attribute sql%rowcount?
Mention what are the benefits of pl/sql packages?
Is sql difficult?
What are the advantages of pl sql?
what is a database? : Sql dba
Does normalization improve performance?
What is difference between sql and mysql?
What will you get by the cursor attribute sql%notfound?
Which is better varchar or nvarchar?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
