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
- 5476 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / subbu
select * from table name where name is not null and
age is not null
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
What is rank index in rank transformation?
Explain pushdown optimization and types in informatica
What does cheating measurement mean?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Explain the different kinds of facts.
explain one complex mapping with logic? sales project?
How to load data in informatica ?
How do you handle two sessions in Informatica
How can we update a record in the target table without using update strategy?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the components of workflow manager?
What are the tasks that can be performed using sq?
Different circumstance which drives informatica server to expel records?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is meant by active and passive transformation?
