Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable(
   id   INTEGER  NOT NULL PRIMARY KEY 
  ,p_id INTEGER  NOT NULL
  ,age  INTEGER  NOT NULL
);

begin
INSERT INTO mytable(id,p_id,age) VALUES (0,00170,64);
INSERT INTO mytable(id,p_id,age) VALUES (1,00170,64);
INSERT INTO mytable(id,p_id,age) VALUES (2,00201,24);
INSERT INTO mytable(id,p_id,age) VALUES (3,00201,64);
INSERT INTO mytable(id,p_id,age) VALUES (4,00201,64);
INSERT INTO mytable(id,p_id,age) VALUES (5,00300,24);
INSERT INTO mytable(id,p_id,age) VALUES (6,00300,20);
end;
/
1 rows affected

select p_id, age
from ( select t.*, count(*) over(order by p_id) cnt from mytable t) t
where cnt <= 4


P_ID
AGE


170
64

170
64


select p_id, age
from ( select t.*, count(*) over(order by p_id) cnt from mytable t) t
where cnt <= 5


P_ID
AGE


170
64

170
64

201
24

201
64

201
64


select p_id, age
from ( select t.*, count(*) over(order by p_id) cnt from mytable t) t
where cnt <= 6


P_ID
AGE


170
64

170
64

201
24

201
64

201
64