1  with t as (
  2  select 1 id ,date '2018-11-09' dat from dual union all
  3  select 1 id ,date '2018-11-09' dat from dual union all
  4  select 1 id ,date '2018-11-09' dat from dual union all
  5  select 1 id ,date '2018-11-09' dat from dual union all
  6  select 1 id ,date '2018-11-09' dat from dual union all
  7  select 1 id ,date '2018-11-09' dat from dual union all
  8  select 1 id ,date '2018-11-09' dat from dual )
  9  select * from
 10  (select trunc(dat)
 11        , id
 12        , dense_rank() OVER (partition by trunc(dat), id order by dat) as rn
 13     from t) z
 14* --where z.rn > 5
SQL> /

TRUNC(DA         ID         RN
-------- ---------- ----------
09.11.18          1          1
09.11.18          1          1
09.11.18          1          1
09.11.18          1          1
09.11.18          1          1
09.11.18          1          1
09.11.18          1          1

7 rows selected.

  1  with t(ID,DOGNUM,SUMMA,DATEOPER) as (
  2  select 1, 123, 100, to_date('08.11.2018 12:01:02','dd.mm.yyyy hh24:mi:ss') from dual union all
  3  select 2, 123, 100, to_date('08.11.2018 12:02:03','dd.mm.yyyy hh24:mi:ss') from dual union all
  4  select 3, 123, 100, to_date('08.11.2018 12:03:04','dd.mm.yyyy hh24:mi:ss') from dual union all
  5  select 4, 123, 100, to_date('09.11.2018 12:05:06','dd.mm.yyyy hh24:mi:ss') from dual union all
  6  select 5, 123, 100, to_date('09.11.2018 12:07:08','dd.mm.yyyy hh24:mi:ss') from dual union all
  7  select 6, 123, 100, to_date('09.11.2018 12:09:10','dd.mm.yyyy hh24:mi:ss') from dual union all
  8  select 7, 123, 100, to_date('09.11.2018 12:11:12','dd.mm.yyyy hh24:mi:ss') from dual union all
  9  select 9, 123, 101, to_date('09.11.2018 12:13:14','dd.mm.yyyy hh24:mi:ss') from dual union all
 10  select 10,123, 102, to_date('09.11.2018 12:13:14','dd.mm.yyyy hh24:mi:ss') from dual union all
 11  select 11,123, 103, to_date('09.11.2018 12:13:14','dd.mm.yyyy hh24:mi:ss') from dual union all
 12  select 12,123, 100, to_date('09.11.2018 12:15:16','dd.mm.yyyy hh24:mi:ss') from dual
 13  )
 14  select * from
 15  (select t.*
 16        , row_number() OVER (partition by dognum,trunc(dateoper) order by dateoper,id) as rn
 17     from t) z
 18* where z.rn > 5
SQL> /

        ID     DOGNUM      SUMMA DATEOPER         RN
---------- ---------- ---------- -------- ----------
        10        123        102 09.11.18          6
        11        123        103 09.11.18          7
        12        123        100 09.11.18          8