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
- 3 Answers
- 6674 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
what are date and time functions in mysql? : Sql dba
Explain the significance of the & and && operators in pl sql.
Show the two pl/sql cursor exceptions.
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What are user defined functions?
what is cursor. write example of it. What are the attributes of cursor.
What is a nested table in word?
How do you modify a table in sql?
How does join work in sql?
What is sqlexception in java?
How do I run sql?
What trigger means?
What are the different types of functions in sql?
Do foreign keys improve performance?
What is a relationship and what are they?
