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
- 15272 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 a dirty read sql?
What is where clause in sql?
What is primary and foreign key?
what is commit? : Sql dba
Why do we use view in sql?
How many parts of a pl sql block are optional?
Can a select statement fire a trigger?
what are the different functions in sorting an array? : Sql dba
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Name the different types of indexes in sql and define them.
How much does sqlite cost?
What are different types of statements supported by sql?
Can we use update in sql function?
How is data stored in sql?
Why do we use function in pl sql?
