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
7798 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 use of set statement in tsql? : Transact sql

993

How do I find duplicates in the same column?

1059

Can we write ddl statements in functions?

1095

How can we debug in PL/SQL?

1119

What does dml mean?

965

Can we update views in sql?

925

What is assignment operator in pl sql?

1017

What is the difference between Union and Union all. Which is faster.

1382

Is left join same as join?

972

What is range partitioning?

948

What is loop in pl sql?

1019

Explain the insert into statements in sql?

983

What is a dynamic query?

1009

What does where 1 1 mean in sql?

1019

give the syntax of grant and revoke commands? : Sql dba

1138