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
- 13615 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
What is pl/sql table? Why is it used?
How can I get the number of records affected by a stored procedure?
What is the function that is used to transfer a pl/sql table log to a database table?
What is a record in a database?
Which version of sql do I have?
tell us something about heap tables. : Sql dba
What are the advantages of indexing?
What is the basic structure of an sql?
What is an emotional trigger?
what is the difference between undefined value and null value? : Sql dba
Are subqueries better than joins?
How do I debug a stored procedure?
What is a parameter query?
what is difference between delete and truncate commands? : Sql dba
What is db journal file?
