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
- 15614 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / dipti
The only option I feel is
SELECT * FROM TABLE
WHERE COL_NAME IS NOT NULL
will return the non null values which I think is asked for
this question.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are inbuilt functions in sql?
how to install mysql? : Sql dba
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How you improve the performance of sql*loader? : aql loader
how to present a past time in hours, minutes and seconds? : Sql dba
How do I view an execution plan in sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
what is the difference between nested subquery and correlated subquery?
How to Declare Fixed Length String Value In PL SQL
When to use inner join and left join?
discuss about myisam index statistics collection. : Sql dba
Do stored procedures prevent sql injection?
What is the maximum number of triggers, you can apply on a single table?
What is procedure explain with example?
What do we need to check in database testing?
