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
- 13571 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
What is data control language?
The select into statement is most often used to create backup copies of tables or for archiving records?
Explain the difference between sql and mysql.
How can we make an if statement within a select statement?
What does data normalization mean?
How do I restart sql?
What are operators available in sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What are different sql data types?
Does truncate table reset auto increment?
How is debugging done?
Why triggers are used?
What is update query?
How do sql databases work?
