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

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

i want the output format like

id name
101 dinesh
102 suresh
103 prakesh

Question Posted / sumit

3 Answers
7797 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / sumit

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

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql injection vulnerability?

928

Define SQL and state the differences between SQL and other conventional programming Languages?

1197

How to use sql statements in pl/sql?

1100

Can we alter stored procedure?

967

What is Collation Sensitivity ? What are the various type ?

937

What is autocommit sql?

969

Is sql free?

928

Why left join is used in sql?

959

How do I create an index in word?

1010

Is it possible to read/write files to-and-from PL/SQL?

1084

Does pdo prevent sql injection?

920

What are the 3 types of behavioral triggers?

1233

what is the use of double ampersand (&&) in sql queries?

1157

What does := mean in pl sql?

1030

What are user defined functions?

994