Gruppierungen in SQL

[andreaspr@aon.at]

wie wärs mit:

Select Sp1, Objekt From                                            
(select max(LFDNR) Sp1 , substring(Objekt , 1, 1) Sp2, Objekt from DIE_Table 
group by Objekt) Tab1                                               
order by tab1.sp2, tab1.sp1 desc