Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15236 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / vijay_1994
please use group function is ignore the null values
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is inner join in sql?
what is the command used to fetch first 5 characters of the string? : Sql dba
What is the process of copying data from table a to table b?
What are few of the schema objects that are created using PL/SQL?
What is the cause of mutating table error and how can we solve it?
what is sql server agent? : Sql dba
What is synonyms?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How do I order columns in sql?
Can we use rowid as primary key?
What is dynamic sql in pl sql?
What is the basic structure of an sql?
What is a trigger in sql?
How do I make sql search faster?
Can a composite key be null?
