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

Which are sql * plus commands?

1125

Why do we use procedures in pl sql?

1039

Name the operator which is used in the query for pattern matching?

945

How to select random rows from a table?

1075

What is pl/sql table? Why is it used?

1042

discuss about myisam index statistics collection. : Sql dba

951

Where is pl sql used?

952

how can we destroy the cookie? : Sql dba

1011

What is the difference between view and stored procedure?

959

what is a database? : Sql dba

1169

Is time a data type in sql?

902

What is Difference Between Unique and Primary Key Constraints?

1105

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269

Is natural join and inner join same?

926

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1345