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

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

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

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

1062

Can you use flat files in Mapplets.

2710

Explain the shared cache and re-cache?

1163

In informatics server which files are created during the session rums?

1164

Explain about cumulative Sum or moving sum?

1090

During the running session, output files are created by informatica server. Enlist few of them.

1020

What is the command used to run a batch?

1109

What do you mean incremental aggregation?

1129

What is meant by a domain?

1186

What is the meaning of up gradation of repository?

2052

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1138

difference between informatica 8.1.1 and 8.6

3729

Explain constraint based loading in informatica

1145

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1161

What is a router transformation?

1210