Interested to Buy Any Domain ? << Click Here >> for more details...
wirte a query to remove null? following table are
col1 col2 col3
dinesh null null
null suresh null
null null prakesh
i want the output like
col1 col2 col3
dinesh suresh prkaesh
- 6 Answers
- 13787 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / apsar
select distinct((select col1 from z1 where no is not null))col1,(select col2 from z1 where sal is not null)col2,select col3 from z1 where col is not null) from z1
Hint:z1 is Table Name
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
When is the explicit cursor used ?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is a loop in sql?
What do you understand by exception handling in pl/sql?
What is denormalization in a database?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is synonyms?
Can a varchar be a primary key?
Explain what is dbms?
discuss about myisam key cache. : Sql dba
How to write html code in pl sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
What is informix sql?
Why trigger is used in sql?
What is posting?
