Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in different tables
with same structure
- 4 Answers
- 9439 Views
- I also Faced
- E-Mail Answers
Answer Posted / umadevi
example
delete from emp where deptno in (select deptno from dept
where emp.deptno=dept.deptno);
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What are all the common sql functions?
Define implicit and explicit cursors.
what is the difference between where clause and having clause? : Sql dba
what does myisamchk do? : Sql dba
What is a unique key and primary key and foreign key?
Do stored procedures prevent sql injection?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is the file extension for sql database?
Do foreign keys improve performance?
How to run sql commands in sql*plus?
What is pl sql commands?
How many disk partitions should I have?
what is sql? : Sql dba
What are the rules to be applied to nulls whilst doing comparisons?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
