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
- 13429 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 the difference between rollback and rollback to statements?
What is dbo in sql?
What is an exception in PL/SQL? What are the two types of exceptions?
What normalization means?
what is a join? : Sql dba
What view means?
Write the alter statement to enable all the triggers on the t.students table.
Explain the commit statement.
Could you please provide oca (oracle 10g) dumps for my certification ?
What is composite data type in pl sql?
How to raise user-defined exception with custom sqlerrm ?
How do you delete data from a table?
What does count (*) mean?
what are all the different types of indexes? : Sql dba
What is auto increment?
