write a query to delete similar records in particular
fields(columns) in different tables
Answer Posted / madhu
delete from emp where emp_no in
(select emp_no from emp2 where emp.emp_no=emp2.emp_no)
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
how to check server status with 'mysqladmin'? : Sql dba
What is schema in sql example?
What does select top 1 do in sql?
What is sql mysql pl sql oracle?
What are the types of keys?
What is difference between inner join and self join?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
how to select unique records from a table? : Sql dba
What is meant by user defined function?
Is not equal in sql?
Does sql*plus have a pl/sql engine?
Can a table contain multiple primary key’s?
What are the possible values that can be stored in a boolean data field?
What is the primary key?