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
- 12830 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / dipti
The only option I feel is
SELECT * FROM TABLE
WHERE COL_NAME IS NOT NULL
will return the non null values which I think is asked for
this question.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to assign sql query results to pl sql variables?
How delete all records from table in sql?
what is clause? : Sql dba
What is offset in sql query?
What are the datatypes available in pl/sql ?
what is a tablespace? : Sql dba
Can cursors be part of a trigger body?
How can I change database name in sql?
how many tables will create when we create table, what are they? : Sql dba
How many types of cursors are available in pl/sql?
What are pl/sql packages?
Does truncate need commit?
What is left join in sql?
How to find 3rd highest salary of an employee from the employee table in sql?
How do I run a program in pl sql?
