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
- 12497 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sivanagaraju
SELECT DISTINCT((SELECT COL1 FROM COLL WHERE COL1<>'NULL')),(SELECT COL2 FROM COLL WHERE COL2<>'NULL'),(SELECT COL3 FROM COLL WHERE COL3<>'NULL')
FROM COLL
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the difference between row level and statement level trigger?
What are local and global Indexes and where they are useful.
what are the disadvantages of mysql? : Sql dba
What is a temporal table?
how can we submit a form without a submit button? : Sql dba
Is sql similar to python?
Can we use insert statement in function?
What is the difference between the implicit and explicit cursors?
Why do we use procedures?
Why is partition used in sql?
What is the difference between the conventional and direct path loads? : aql loader
what happens if null values are involved in expressions? : Sql dba
How does cross join work in sql?
What is pl sql block in dbms?
What is a system versioned table?
