Answer / vinoth kumar

DELETE FROM table1 WHERE
(col1,col2,..) IN (SELECT col1,col2,.. FROM table2 where
condition)

Answer / radha sri seshu.kolla

while creating table and giving foreign key constraint give
the key word 'on delete cascade'.automatically when the
record in the master table is delated the relaeted record
in the detail table will also be deleted.

Answer / umadevi

example

delete from emp where deptno in (select deptno from dept
where emp.deptno=dept.deptno);

Answer / senthil

This done by Co-related sub-query:- based upon ROWID
uniqness this deletes the duplicate rows.

Delete from emp x where ROWID != (Select MIN(ROWID) from
emp y where y.empno = x.empno);

Why we use sql profiler?

0 Answers  

---

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

---

How to remove duplicate rows from a table?.

3 Answers  

---

what is the difference between truncate and drop statements? : Sql dba

0 Answers  

---

Is primary key is clustered index?

0 Answers  

---

What are the advantages of pl sql over sql?

0 Answers  

---

How would you convert date into julian date format?

0 Answers  

---

What is data control language (dcl)?

0 Answers  

---

How do I run a script in sql developer?

0 Answers  

---

what is the difference between delete and truncate commands? : Sql dba

0 Answers  

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---

How much does sql certification cost?

0 Answers  

---