select id,name from tablename where id in(101,102,103)

write sql query to remove null value following table
id name
101 dinesh
null jyothi
null bharathi
102 suresh
null shilpha
103 prakesh
null suma

i want the output

id name
101 dinesh
102 suresh
103 prakesh

Question Posted / a.venkata lakshmi

5 Answers
11371 Views
Accenture, I also Faced
E-Mail Answers

Answer Posted / a.venkata lakshmi

select id,name from tablename where id in(101,102,103)

Is This Answer Correct ?

0 Yes

11 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a joiner transformation?

940

What are the components of Informatica? And what is the purpose of each?

982

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2122

What is a filter transformation?

990

How might one distinguish in the case of mapping is right or not without associating session?

1028

Enterprise data warehouse your projects phase by phase explain?

1856

How can you validate all mappings in the repository simultaneously?

1289

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1052

In informatica workflow manager, how many repositories can be created?

1271

What is workflow manager?

991

Can we change Dynamic to Static or Persistent cache? If so what happens?

2152

Enlist few areas or real-time situations where informatica is required.

1022

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

1039

Reusable transformation and shortcut differences

1782

What is a shortcut and copy in Informatica and how two are different with each other?

1132