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
- 13812 Views
- TCS, I also Faced
- E-Mail Answers
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 rollback statement?
Which is faster view or stored procedure?
What is the maximum number of columns in sql table?
what is the command used to fetch first 5 characters of the string? : Sql dba
Difference between truncate, delete and drop commands?
Explain spool.
Why do we go for stored procedures?
What is not equal in sql?
Why do we use set serveroutput on?
What is full join?
How do I find duplicates in sql?
Why use subqueries instead of joins?
what is self join and what is the requirement of self join? : Sql dba
How many sql commands are there?
Define a temp table?
