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
6102 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

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1076

What are junk dimensions?

1058

What are the different versions of informatica?

1249

Differentiate between joiner and lookup transformation?

1095

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4132

How to extract the informatica rejected data?

1201

Enlist some properties of sessions.

1057

Define update strategy?

1198

How can you generate reports in informatica?

1010

Mention few power centre client applications with their basic purpose?

932

How to join three sources using joiner?

1084

can u give example for factless fact table

6604

How to handle decimal places while importing a flatfile into informatica?

1181

Enlist the various types of transformations.

1027

How do you update the records with or without using update strategy?

1100