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
- 13613 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ajitnayak
select distinct col1 from samp
where col1 is not null
union all
select distinct col2 from samp
where col2 is not null
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of cursors in pl/sql?
What are triggers and its uses?
What are the operators in sql?
What are the two types of cursors in pl sql?
what is the difference between undefined value and null value? : Sql dba
Is sql dba a good career? : SQL DBA
What is trigger in sql?
What is secondary key?
What is scope and visibility in PL/SQL?
Is left join inner or outer?
What is embedded sql with example?
How do I access sql anywhere database?
What is a constraint? Tell me about its various levels.
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
Explain the purpose of %type and %rowtype data types?
