By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE TEST1
("PROJECT_NAME" NUMBER,
"OK_CRITERIUM" NUMBER,
"DDATE" DATE
) ;
Insert into test1 (PROJECT_NAME,OK_CRITERIUM,DDATE) values ('241','1','21-DEC-2019');
1 rows affected
Insert into test1 (PROJECT_NAME,OK_CRITERIUM,DDATE) values ('241','1',to_date('21.12.2019 00:00:00','DD.MM.RRRR HH24:MI:SS'));
1 rows affected
Insert into test1 (PROJECT_NAME,OK_CRITERIUM,DDATE) values ('241','0',to_date('26.12.2019 00:00:00','DD.MM.RRRR HH24:MI:SS'));
1 rows affected
Insert into test1 (PROJECT_NAME,OK_CRITERIUM,DDATE) values ('241','0',to_date('26.12.2019 00:00:00','DD.MM.RRRR HH24:MI:SS'));
1 rows affected
Insert into test1 (PROJECT_NAME,OK_CRITERIUM,DDATE) values ('241','1',to_date('01.01.2020 00:00:00','DD.MM.RRRR HH24:MI:SS'));
1 rows affected
Insert into test1 (PROJECT_NAME,OK_CRITERIUM,DDATE) values ('241','0',to_date('01.01.2020 00:00:00','DD.MM.RRRR HH24:MI:SS'));
1 rows affected
select * from test1;
| PROJECT_NAME | OK_CRITERIUM | DDATE |
|---|---|---|
| 241 | 1 | 21-DEC-19 |
| 241 | 1 | 21-DEC-19 |
| 241 | 0 | 26-DEC-19 |
| 241 | 0 | 26-DEC-19 |
| 241 | 1 | 01-JAN-20 |
| 241 | 0 | 01-JAN-20 |
select
row_number () over (partition by project_name,ok_criterium, ddate order by ddate asc ) as rn,
t1.*
from test1 t1 order by ddate
| RN | PROJECT_NAME | OK_CRITERIUM | DDATE |
|---|---|---|---|
| 1 | 241 | 1 | 21-DEC-19 |
| 2 | 241 | 1 | 21-DEC-19 |
| 1 | 241 | 0 | 26-DEC-19 |
| 2 | 241 | 0 | 26-DEC-19 |
| 1 | 241 | 0 | 01-JAN-20 |
| 1 | 241 | 1 | 01-JAN-20 |