row_number() over(PARTITION BY

1.create table lcy_p(id number,name varchar2(30));

2.insert into lcy_p values(1,'li1');
insert into lcy_p values(1,'li2');
insert into lcy_p values(2,'wang1');
insert into lcy_p values(2,'wang2');
insert into lcy_p values(3,'hu1');
insert into lcy_p values(3,'hu2');
insert into lcy_p values(4,'gan');
insert into lcy_p values(5,'xin');
insert into lcy_p values(6,'kai');
insert into lcy_p values(7,'nan');

3.select * from (select row_number() over(PARTITION BY ID ORDER BY NAME) AS ROW_NO,
p.*
from lcy_p p )X
WHERE ROW_NO =1;

result：

ROW_NO    ID    NAME
1    1    li1
1    2    wang1
1    3    hu1
1    4    gan
1    5    xin
1    6    kai
1    7    nan