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
- 12151 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 do I view tables in sql developer?
What does plv msg allows you to do?
How do I edit a trigger in sql developer?
What is sql engine in oracle?
how to drop an existing table in mysql? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
what are all the common sql function? : Sql dba
Can we use joins in subquery?
Why function is used in sql?
Why schema is used in sql?
What type of database is cloud sql?
How long will it take to learn pl sql?
What is pragma in pl sql?
Can you do multiple joins in sql?
What are synonyms in sql?
