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
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
How do I partition a table in sql?
Where can I learn sql for free?
What does := mean in pl sql?
Why self join is used in sql?
How to write pl sql program in mysql command prompt?
How do you write an inner join query?
What is AUTH_ID and AUTH_USER in pl/sql ?
What are the 3 modes of parameter?
What is cross join sql?
What is minus?
How to display the records between two range in Oracle SQL Plus?
Define implicit and explicit cursors.
What is a pdo connection?
How to Execute a Package in PL/SQL.?
What is java sql package?