Código SQL [-]select max(clave), ref, ref_precedente from tabla where ref_precedente=1 group by ref, ref_precedente
select max(clave), ref, ref_precedente from tabla where ref_precedente=1 group by ref, ref_precedente