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
7963 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 csv? : Sql dba

1049

How insert into statements in sql?

1122

What is over () in sql?

1013

Can we rollback delete command?

1038

Define a temp table?

1081

What is the difference between left and left outer join?

994

Is the primary key an index?

1078

What is sql*loader and what is it used for? : aql loader

1249

What is right join in sql?

1157

What is difference between inner join and self join?

1134

What is package in pl sql?

1086

What are the differences between implicit and explicit cursors?

1109

What are all the different normalizations?

1078

Is left join faster than inner join?

1168

What is a .db file?

1042