SNO  SNAME SECTION
1    RAM     A
2    SHYAM   B
2    SHYAM   B
3    KISHOR  C
3    KISHOR  D
4    RAMESH  E
5    RAJESH  F
5    RAJESH  F

SNO  SNAME SECTION
1     RAM     A
2     SHYAM   B
3     KISHOR  C
3     KISHOR  D
4     RAMESH  E
5     RAJESH  F    

CREATE TABLE table_duplicate(sno NUMBER,sname VARCHAR2(20),section CHAR(1));

INSERT INTO table_duplicate VALUES(1,'RAM','A');
INSERT INTO table_duplicate VALUES(2,'SHYAM','B');
INSERT INTO table_duplicate VALUES(2,'SHYAM','B');
INSERT INTO table_duplicate VALUES(3,'KISHOR','C');
INSERT INTO table_duplicate VALUES(3,'KISHOR','D');
INSERT INTO table_duplicate VALUES(4,'RAMESH','E');
INSERT INTO table_duplicate VALUES(5,'RAJESH','F');
INSERT INTO table_duplicate VALUES(5,'RAJESH','F');

       SNO SNAME		S   COUNT(*)
---------- -------------------- - ----------
	 1 RAM			A	   1
	 2 SHYAM		B	   2
	 3 KISHOR		C	   1
	 3 KISHOR		D	   1
	 4 RAMESH		E	   1
	 5 RAJESH		F	   2

DELETE FROM pink_slippers
WHERE rowid not in
(SELECT MIN(rowid) 
FROM pink_slippers 
GROUP BY column1, column2, column3...);

CREATE TABLE fuzzy_polka_dot_slippers 
AS SELECT DISTINCT * 
FROM old_tattered_shoes;