By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH TABLE1 (ID, NAME, VALUE) AS
(
SELECT 12, 'KREA', 3.7 FROM DUAL UNION ALL
SELECT 13, 'KREA', 12.6 FROM DUAL UNION ALL
SELECT 12, 'GFR', 2.2 FROM DUAL UNION ALL
SELECT 13, 'GFR', 1.7 FROM DUAL
)
select rps1.id, rps1.name, rps1.value, rps2.id, rps2.name, rps2.value
from table1 rps1, table1 rps2
where rps1.name like 'KREA'
AND rps2.name like 'GFR' and rps1.id = rps2.id
--and crd > '17.07.2019 00:00:00'
order by rps1.id
| ID | NAME | VALUE | ID | NAME | VALUE |
|---|---|---|---|---|---|
| 12 | KREA | 3.7 | 12 | GFR | 2.2 |
| 13 | KREA | 12.6 | 13 | GFR | 1.7 |