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
- 13443 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / lavanya
suppose we hav,table name: demo
values
------
1
2
3
NULL
3
4
1
5
NULL
select values from demo where values!=NULL
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What is %s in sql?
What does sql stand for?
how would you enter characters as hex numbers? : Sql dba
What is pls_integer in pl sql?
What is the default isolation level in sql server? : Transact sql
What are triggers in sql?
what is a cursor? : Sql dba
How many types of literals are available in pl sql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is the usage of nvl function?
What is the requirement of self-join?
Is sql better than excel?
Is trigger a stored procedure?
How do I start pl sql?
Explain spool.
