Could not interpret path expression ‘rownum’

I have this Oracle query implemented as HQL and Spring Boot query which I want to migrate to PostgreSQL