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
- 12085 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / hiya
SELECT REPLACE(A,'NULL',' '),
REPLACE(B,'NULL',' '),
REPLACE(C,'NULL',' ')FROM TEST1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is embedded sql with example?
What does select count (*) mean in sql?
How do I view a sql trace file?
what is a composite primary key ? : Sql dba
What is use of package in pl sql?
How to place comments in pl/sql?
What is the difference between cluster and non-cluster index?
what is the command line end user interface - mysql? : Sql dba
What is the purpose of using pl/sql?
What is a left inner join?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
who introduced sql?
How many primary keys can a table have?
Can we create table in function?
What is the default isolation level in sql server? : Transact sql
