Answer / pravin jadhav

delete from table_name where rowid not in (select max(rowid) from table group by
duplicate_values_field_name);
or
delete duplicate_values_field_name dv from table_name ta where rowid <(select min(rowid) from
table_name tb where ta.dv=tb.dv);

Answer / paks

using rownum .


Select * from
(Select name,id, Row_number () over (partition by name order by id desc) rn from tblname)
Where rn=1;

Answer / k.sailesh

We can find duplicate rows from two tables by using select *
from table name. it displays all the values repeated and unique.
We can delete duplicate rows by using Primary key constraint.

what are different types of deletes?

1 Answers  

---

What is the difference between PFILE and SPFILE in Oracle?

0 Answers   MCN Solutions,

---

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  

---

How to call a sub procedure?

0 Answers  

---

How will you identify oracle database software release?

0 Answers  

---

How to write text literals in oracle?

0 Answers  

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

What is Database Link ?

2 Answers  

---

what is reindexing?

0 Answers   Tata Technologies,

---

What happens if you use a wrong connect identifier?

0 Answers  

---

what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .

5 Answers   HCL, LN,

---

Explain index?

0 Answers  

---