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
11615 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 are the components of the workflow manager?

1137

What are multi-group transformations?

1108

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

1480

Define sessions in informatica etl?

1039

What is the difference between informatica 7.0 and 8.0?

1016

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2069

What is the difference between stop and abort in informatica

1097

How to partition the Session?

1114

What is a difference between complete, stop and abort?

1086

What are the different ways to implement parallel processing in informatica?

1426

What are the uses of etl tools?

1129

What do you mean by enterprise data warehousing?

1066

How to extract sap data using informatica? What is abap? What are idocs?

1183

Explain the types of lookup transformation?

1046

What is the difference between a repository server and a powerhouse?

1513