create table test_ora
(
no number,
name varchar2(15),
dept varchar2(15),
medal varchar2(15)
);
insert into test_ora values(1,'alg','cse','gold');
insert into test_ora values(2,'alg','cse','gold');
insert into test_ora values(3,'alg','cse','gold');
insert into test_ora values(4,'alg','cse','gold');
insert into test_ora values(5,'alg','cse','silver');
insert into test_ora values(6,'alg','cse','silver');
insert into test_ora values(7,'alg','cse','silver');
SQL> select * from test_ora;
NO NAME DEPT MEDAL
---------- --------------- --------------- ---------------
1 alg cse gold
2 alg cse gold
3 alg cse gold
4 alg cse gold
5 alg cse silver
6 alg cse silver
7 alg cse silver
7 rows selected
I want to select only master record like follows and need to delete the other records except the other records show below
SQL> select * from test_ora;
NO NAME DEPT MEDAL
---------- --------------- --------------- ---------------
1 alg cse gold
5 alg cse silver
can you help me through query ?