select * from table name where name is not null and

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

2 Answers
6241 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

Please Help Members By Posting Answers For Below Questions

What is meant by target load plan?

1026

What does refresh system mean, and what are its distinctive choice?

1269

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1314

Explain the types of transformations?

1097

How can you define user defied event?

1073

How do you manage the Parameter files while migrating your data from one environment to another environment?

1065

Explain the aggregator transformation?

1219

How are indexes created after completing the load process?

1717

Briefly explain the aggregator transformation?

1063

How many ways are there to do 'remove duplicate records in informatica'?

1062

Repository user profiles

1811

What is the maplet?

1200

Is it possible to use a client with different version than that of its Informatica server?

1189

How to partition the Session?

1149

What is a filter transformation?

1090