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
- 12510 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sivanagaraju
SELECT C1.COL1,C2.COL2,C3.COL3
FROM COLL C1,(SELECT COL2 FROM COLL WHERE COL2 <>'NULL') C2,
(SELECT COL3 FROM COLL WHERE COL3<>'NULL') C3
WHERE C1.COL1<>'NULL';
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can we create a trigger on view?
What is normalisation in sql?
what is a table in a database ? : Sql dba
Is pl sql and postgresql same?
How can you fetch first 5 characters of the string?
What is difference between pls_integer and integer?
How to find 3rd highest salary of an employee from the employee table in sql?
What is indexes?
What is the difference between nested table and varray?
What is sql used for?
How does one load ebcdic data? : aql loader
What does an inner join do?
What is procedure and function in sql?
What is the difference between clustered and non-clustered index in sql?
discuss about myisam key cache. : Sql dba
