Select Code to Download

select li_i.id, description from list_index li_i
join (
    select id, max(rpt_key) as rpt_key from list_index group by id
) li_o
on li_i.id = li_o.id and li_i.rpt_key = li_o.rpt_key;