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

Is mariadb a nosql database?

1007

Why use triggers in sql?

897

Is sql developer case sensitive?

945

what are the types of join and explain each? : Sql dba

991

What pl/sql package consists of?

1033

Is it possible to update views?

919

How do you optimize a query?

941

Define select, insert, create, delete, update, drop keywords

997

What is sql partition?

1038

How do I save a sql query?

962

Does inner join remove duplicates?

888

What is the need of a partition key?

942

What is the syntax to add a record to a table?

1023

What is sqlite format?

1113

Explain what is a view?

998