Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11577 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / a.venkata lakshmi
select id,name from tablename where id in(101,102,103)
| Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
Explain what transformation and how many are there in informatica?
What is the difference between informatica 7.0 and 8.0?
State the differences between sql override and lookup override?
What are the steps involved in the migration from older version to newer version of Informatica Server?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is a sorter transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What do think which one is the better joiner or look up?
What is the scenario which compels informatica server to reject files?
What is transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to load last n records of file into target table - informatica
What is deployment group?
How can a transformation be made reusable?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
