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
- 12496 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 a secondary key?
Is keyword pl sql?
What is data type in sql?
Why is partition used in sql?
How to run pl sql program in mysql?
How do you respond to dementia behavior?
What is graph sql?
how to use in conditions? : Sql dba
write an sql query to find names of employee start with 'a'? : Sql dba
What is sql table?
Can a composite key be null?
Is like operator in sql case sensitive?
What do you understand by pl/sql packages?
Does mysql support pl sql?
What is raid? How does it help storage of databases?
