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
7727 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 difference between stored function and application function?

1126

What is cursor explain with example?

938

How do you select unique values in sql?

958

What is a ddl command?

1021

explain the advantages and disadvantages of stored procedure? : Sql dba

969

What is posting?

999

Why are indexes and views important to an organization?

912

What is the best sql course?

948

What is the use of nvl function?

1136

What is pl sql variable?

949

What is the source code of a program?

1020

What is right join in sql?

1040

What is an invalid partition table?

975

can a stored procedure call itself or recursive stored procedure? : Sql dba

970

Why do we use partitions in sql?

995