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
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
Which sql statement is used to return only different values?
Does group by remove duplicates?
What is rank dense_rank and partition in sql?
how to show all tables with 'mysql'? : Sql dba
What is difference between stored procedure and trigger?
What is a file delimiter?
Explain normalization and what are the advantages of it?
What is difference between sql and oracle?
How can you load microsoft excel data into oracle? : aql loader
what is bdb (berkeleydb)? : Sql dba
Enlist the data types that can be used in pl/sql?
Is merge a dml statement?
what is dbms? : Sql dba
What is trigger explain it?
how to load data files into tables with 'mysqlimport'? : Sql dba