write sql query to filter the null value data following
table?
name age
john 30
smith null
null 34
sharp 24
i want the output following are
name age
john 30
sharp 24
- 2 Answers
- 5477 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / karthis4u
select * from table name where name is not null OR
age is not null
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
what is unit testing?tell me proceedure
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How can you differentiate between powercenter and power map?
How to update source definition?
What is the session task and command task?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How does a sorter cache works?
How to generate sequence numbers using expression transformation?
Explain direct and indirect flat file loading (source file type) - informatica
What are the prerequisite tasks to achieve the session partition?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Clarify the utilization of aggregator cache record?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is complex mapping?
