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
- 11589 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
Target increases every day even though no new record was inserted
How to join three sources using joiner?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How we can create indexes after completing the load process?
What are the databases that informatica can connect to windows?
can anyone suggest best free Talend data integration training online
What differs when we choose the sorted input for aggregator transformation?
How to do the error handling of if ur source is flatfiles?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What can we do to improve the performance of informatica aggregator transformation?
How to update source definition?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain the difference between mapping parameter and mapping variable?
How many ways are there to create ports?
design of staging area?
