select * from
 (select ...
    ,row_number() over (partition by id order by dat ) rn 
 ) where rn=1

  1  with t (id,shara,dat,percent) as (
  2  select 1,1001,date '2018-06-25',7 from dual union all
  3  select 1,1002,date '2018-07-01',5 from dual union all
  4  select 2,2002,date '2018-06-21',3 from dual)
  5  select id,min(shara),min(dat) dat, min(percent) percent
  6  from t
  7* group by id
SQL> /

        ID MIN(SHARA) DAT         PERCENT
---------- ---------- -------- ----------
         1       1001 25.06.18          5
         2       2002 21.06.18          3

SQL> ed
Wrote file afiedt.buf

  1  with t (id,shara,dat,percent) as (
  2  select 1,1001,date '2018-06-25',7 from dual union all
  3  select 1,1002,date '2018-07-01',5 from dual union all
  4  select 2,2002,date '2018-06-21',3 from dual)
  5  select * from (
  6  select id,shara,dat, percent
  7    ,row_number() over (partition by id order by dat) rn
  8  from t)
  9* where rn=1
SQL> /

        ID      SHARA DAT         PERCENT         RN
---------- ---------- -------- ---------- ----------
         1       1001 25.06.18          7          1
         2       2002 21.06.18          3          1

SQL>