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

Tell me about Propagate functions in informatica

922

Explain sessions. Explain how batches are used to combine executions?

1033

What are the popular informatica products?

1012

tell me 5 session failure in real time how can you solve that in your project?

2304

Explain in detail about scd type 1 through mapping.

1555

How to improve the performance of a session using sorter transformation?

1146

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1132

What is InformaticaPowerCenter?

1136

What is transformation?

1099

How to Create a folder using pmrep command?

1174

Explain what are the different versions of informatica?

1098

What could be the possible resons of locks by user?

1094

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1910

How you know when to use a static cache and dynamic cache in lookup transformation?

1855

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1953