select id, name from table where id is not null;

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

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

Answer Posted / rama

select id, name from table where id is not null;

Is This Answer Correct ?

20 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain in detail about scd type 1 through mapping.

1524

Explian the Process of deployment groups in informatica

1056

Explain your project of banking domian.

1647

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1897

What is the need for an etl tool?

1062

Differences between connected and unconnected lookup?

1211

What are mapplets? How is it different from a Reusable Transformation?

1082

What do you understand by a term domain?

1120

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10675

Define the various join types of joiner transformation?

986

What is standalone command task?

1310

How can a transformation be made reusable?

1155

How to partition the Session?

1105

Explain the etl program with few examples.

1042

What are the types of lookup transformation?

1067