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
- 15616 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 sql? : Sql dba
how to do backup entire database? : Transact sql
Is there a 64 bit version of ssms?
Why primary key is required?
what are integrity rules?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is rename command in sql?
Does normalization improve performance?
Why do we use triggers?
What is sql and explain its components?
What is the maximum size of sqlite database?
how to show all tables with 'mysql'? : Sql dba
What are the sql commands?
What are tables and fields?
What is the most common sql injection tool?
