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