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
- 13782 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 rowid in sql?
When should I use nosql database?
how to fetch alternate records from a table? : Sql dba
Why do we use procedures in sql?
Enlist the advantages of sql.
What does over partition by mean in sql?
What is the difference between rename and alias?
What is pl sql in oracle?
Can we insert in view in sql?
What jobs use sql?
What are the types of records?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What are dml commands?
How do you use a while loop in pl sql?
Does a join table need a primary key?
