Delete from <tab_name> where id is 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 / ajit nayak

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

Answer Posted / ajit nayak

Delete from <tab_name>
where id is 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 the difference between primary key and unique key? : Sql dba

1042

What is sql entity?

1109

What is pivot table in sql?

1115

what is user defined functions? : Sql dba

1038

What do you mean by “trigger” in sql?

1086

What are dml commands?

1026

What are the commands used in sql?

1085

What is blind sql injection?

1079

Can instead of triggers be used to fire once for each statement on a view?

963

Explain the advantages and disadvantages of stored procedure?

1153

Why do we use partitions in sql?

1056

What are the built in functions of sql?

1031

Can we change the table name in sql?

948

What is inner join in sql?

1087

Is it possible for a table to have more than one foreign key?

1033