Oracle record duplication

Table: -- Create Table
Create Table location
(
Loc nvarchar2 (15) not null,
Description nvarchar2 (40 ),
Userid nvarchar2 (20 ),
Createby varchar2 (30 ),
Createtime date,
Modifyby varchar2 (30 ),
Lastmodifytime date,
Storearea_code varchar2 (4 ),
Storekeeper varchar2 (20)
)

I. Searching duplicate records
1. Search for all Repeated Records

Select * from location L where L. storekeeper in (select L. storekeeper from location group by L. storekeeper having count (*)> 1)
2. Filter duplicate records (only one record is displayed)

Select * from location L where rowid in (select max (rowid) from location L group by L. storekeeper)

II. Delete duplicate records
1. Delete all duplicate records (use with caution)
Delete location L where L. storekeeper in (select L. storekeeper from location L group by L. storekeeper having count (*)> 1)

2. Retain one
Delete location where rownum not in (select max (rownum) from location L group by L. storekeeper)

(Original)