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
- 12152 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 are the advantages of sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Explain what is a view?
Is there a 64 bit version of ssms?
Explain the methods used to protect source code of pl/sql.
Is primary key always clustered index?
how is myisam table stored? : Sql dba
Can we use two order by clause in query?
What are the differences between implicit and explicit cursors?
What is materialized view. What are different methods of refresh?
What is a heap in sql?
Why is sql better than hql?
What is the difference between functions, procedures, and packages in pl/sql?
What is sql and its types?
How to disable a trigger name update_salary?
