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
- 13810 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 database white box testing and black box testing?
how would you get the current date in mysql? : Sql dba
Is record in oracle pl sql?
What is the difference between the sql*loader and import utilities? : aql loader
What is thread join () in threading?
Why join is faster than subquery?
Is primary key clustered or nonclustered?
How do you use a while loop in pl sql?
Describe types of sql statements?
what is a view? : Sql dba
what are the drivers in mysql? : Sql dba
What is pl sql script?
How many subqueries can be nested in a statement?
How are functions and procedures called in PL/SQL?
how to concatenate two character strings? : Sql dba
