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
6010 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 the function of aggregator transformation?

1015

What is a pre-defined event and user-defined event?

971

Mention some types of transformation?

990

Define enterprise data warehousing?

1128

What is meant by lookup transformation? Explain the types of lookup transformation?

895

Is stop and abort are same in informatica?

946

What is decode in informatica?

1071

Explain sessions?

977

How to elaborate tracing level?

1117

How to configure mapping in informatica?

1116

Explain in detail about scd type 1 through mapping.

1295

What differs when we choose the sorted input for aggregator transformation?

966

What is a sequence generator transformation?

950

How might you approve all mappings in the archive all the while?

955

What is substr in informatica?

1131