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
- 13428 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
What is a primary key example?
How do you concatenate in sql?
What is synonyms?
How can you load microsoft excel data into oracle? : aql loader
What is the use of double ampersand (&&) in sql queries? Give an example
What is the cause of mutating table error and how can we solve it?
Does view contain data?
Which sql statement is used to delete data from a database?
What are the disadvantages of file system?
How can we make an if statement within a select statement?
What is a subquery in sql?
what is the difference between blob and text? : Sql dba
How to get each name only once from an employee table?
What are the commands used in sql?
Which are sql * plus commands?
