select * 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 / kart

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

Answer Posted / kart

select * from table where id is not null;

Is This Answer Correct ?

17 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the example of procedure?

928

What is pl/sql language case sensitive?

1125

what is union? : Sql dba

1027

How do I clear the screen in sql plus?

1041

Why do we need sharding?

989

What is posting?

1039

What are its different types of dbms?

1005

Mention what are different methods to trace the pl/sql code?

1206

What are string functions in sql?

1241

What is sql lookup?

919

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

960

Can we call a function containing dml statements in a select query?

979

Why primary key is required?

1006

What are the various restrictions imposed on view in terms of dml?

965

What is the difference between microsoft access and sql server?

1059