write sql query to remove null value following table
id name
101 dinesh
null jyothi
null bharathi
102 suresh
null shilpha
103 prakesh
null suma
i want the output
id name
101 dinesh
102 suresh
103 prakesh
- 5 Answers
- 9804 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / rama
select id, name from table where id is not null;
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
EXL informatica Questions
What is meant by query override?
Explain Dataware house architecture .how data flow from intial to end?
Is it possible to revert a global repository to local one and why?
How union transformation is used?
How can repository reports be accessed without sql or other transformations?
Can informatica load heterogeneous targets from heterogeneous sources?
How do you use reject loader.
What is difference between a gateway node and worker node?
Why update strategy and union transformations are active? Explain with examples.
What are the differences between a connected lookup and unconnected lookup?
What is complex mapping?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the difference between informatica 7.0 and 8.0?
