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
7699 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 are the disadvantages of mysql? : Sql dba

1074

How can I speed up sql query?

904

What is rollback?

1032

What is oracle sql called?

859

what does the t-sql command ident_incr does? : Transact sql

1009

Explain the difference between 'between' & 'and' operators in sql

944

What is sql resultset?

928

Is sql pronounced sequel or sql?

1210

How to avoid using cursors?

1035

Is ms sql traffic encrypted?

867

Is it important to partition hard disk?

964

Why we use join in sql?

911

Why do we need unique key in a table?

882

what is a database transaction? : Sql dba

1103

What are two statement types in sql?

1028