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

Which sql statement is used to return only different values?

954

Can we write dml inside a function in sql server?

900

Why is theta join required?

1081

How many tables can a sql database have?

927

What is the difference between cluster and non-cluster index?

1050

What is microsoft t sql?

882

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1161

Why do we use set serveroutput on?

926

What does subquery mean in sql?

992

Can you do multiple joins in sql?

977

What is the need of merge statement?

989

What is substitution variable?

1003

What are sql ddl commands?

1020

How to avoid using cursors?

1041

What is difference between my sql and sql?

997