PostgreSQL - Select only newer value
maybe:
with latest as (
select element_name, element_sequence, max(creationdate) max_date from table group by element_name, element_sequence
)

select * --your column list
from table t
join latest lt on (lt.element_name = t.element_name and lt.element_sequence = t.element_sequence and lt.max_date = t.creationdate)

or
 select * from 
 (
 select element_name, element_sequence
, row_number() over (partition by element_name, element_sequence order by creationdate desc) lp -- you can add other columns
  from table 
  ) d
    where lp = 1