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
- 15154 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 scheduled jobs or what is a scheduled tasks? : Sql dba
What is the usage of when clause in trigger?
What is the location of pre_defined_functions.
how to convert numeric values to character strings? : Sql dba
How to get help at the sql prompt?
Can we use having without group by in sql?
What are the types of variables use in pl sql?
What is faster join or subquery?
How to check if a column is nullable before setting to nullable?
What is union, minus and interact commands?
Does sql profiler affect performance?
How do you modify a trigger?
Which kind of parameters cannot have a default value in pl sql?
Write a sql query to convert all character to uppercase after hypen.
What are the advantages of stored procedure?
