Hast du das schon probiert?

Code:
select sp1, sp2  from                                        
(select max(LFDNR) sp1 , sp2 from                            
         (select cmdnr , Alpha1 Concat Alpha2 Concat Alpha3 Sp2 from DIE_Table 
          ) tab1                                             
group by sp2) Tab2                                           
order by tab2.sp2, tab2.sp1 desc