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 / kart
select max(col1) col1,max(col2) col2,max(col3) col3
from table;
col1 col2 col3
dinesh suresh prkaesh
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
How do I edit a trigger in sql developer?
What is pl/sql table? Why it is used?
How do I start sql from command line?
Why do we use cursors?
explain commit and rollback in mysql : sql dba
What is a table?
What does trigger mean in psychology?
does sql support programming? : Sql dba
What is self-join and what is the requirement of self-join?
What is the benefit of foreign key?
what is a record in a database ? : Sql dba
What is an intersect?
What is the purpose of my sql?
What is raw datatype in sql?
How do you sort in sql?