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
Explain the select statement in sql?
define sql insert statement ? : Sql dba
What is trigger in flip flop?
explain what is mysql? : Sql dba
Is left join inner or outer by default?
Is sql database free?
What is dba in sql? : SQL DBA
What is union, minus and interact commands?
who introduced sql?
Can we create a trigger on view?
What is asqueryable?
Can a trigger call a stored procedure?
Is join and inner join the same?
Which table is left in left join?
What is multiple partition?