write sql query to filter the null value data following table? name age joh

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

Question Posted / dinesh

2 Answers
6095 Views
HP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write sql query to filter the null value data following table? name age john 30 smith null n..

Answer / subbu

select * from table name where name is not null and
age is not null

Is This Answer Correct ?

17 Yes

2 No

write sql query to filter the null value data following table? name age john 30 smith null n..

Answer / 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

More Informatica Interview Questions

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers

how to get max value record into one target and remaining records into another target?

2 Answers Accenture,

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers

What is source qualifier transformation in informatica?

0 Answers

What are connected or unconnected transformations?

0 Answers Informatica,

What is the sql query overwrite in source qualifier in informatica

0 Answers Informatica,

Describe two levels in which update strategy transformation sets?