write a query to delete similar records in particular
fields(columns) in different tables
- 6 Answers
- 12722 Views
- TCS, I also Faced
- E-Mail Answers
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
How do temporal tables work?
What are the built in functions of sql?
which tcp/ip port does sql server run on? : Sql dba
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is sql indexing?
What is null in pl/sql?
Can we use the cursor's to create the collection in PL/SQL?
What are views in sql?
Explain locks? : Transact sql
How can we find duplicate records in a table?
How many commands are in sql?
What is the purpose of a secondary key?
What is bulk collect in pl sql?
Does mysql support pl sql?
What are the operators in sql?
