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
- 13415 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
How do I count rows in sql query?
How do you add a column to a table?
how to show all tables with 'mysql'? : Sql dba
Why are aggregate functions called so?
What are the different sql commands?
Explain dml and ddl?
what are all the different normalizations? : Sql dba
What is right join in sql?
how do you know if your mysql server is alive? : Sql dba
what does the t-sql command ident_incr does? : Transact sql
What are the types of views in sql?
Why do we use sql constraints?
What are tables and fields in the database?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What is the use of prepared statement?
