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
6118 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 a code page?

1169

How can repository reports be accessed without sql or other transformations?

1209

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2116

What do you mean by channel change?

1037

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

1002

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5777

Mention few advantages of router transformation over filter transformation.

1019

What is the need for an etl tool?

1063

Differentiate between source qualifier and filter transformation?

1572

Design time, run time. If you don't create parameter what will happen

1831

difference between repository database and repository service?

1144

Difference between Target-based loading and constraint-based loading?

992

Can we get 1st record through Informatica(without sequence number).

1472

Difference between Data and Index Caches?

1134

What is a snowflake schema?

990