MAPPE              ABT      INDEX      STATUS    TXT
01255               PT1      1            IA             Änderung1
01255               PT1      2            OF             Änderung2
01255               PT1      3            FR             Änderung3
01111               PT2      1            IA             Änderung1
01111               PT2      2            OF             Änderung1
01111               PA       1            IA             Änderung1
01111               PA       2            OF             Änderung1
  

01111               PT2      2            OF             Änderung1

select * from t_edm_maer139 WHERE (mani,manr,usgr) in (select distinct on (manr)mani,manr,usgr from t_edm_maer139 WHERE usgr LIKE 'PT%' order by manr,mani DESC )  AND stat NOT LIKE 'FR' ORDER BY manr

SELECT * FROM table WHERE abt LIKE 'PT%' AND status != 'FR' AND HAVING index_col = max(index_col);