>select T.* from Tab1 T inner join (select Field1, Field2, min(PK) as MinPK from Tab1 GROUP BY Field1, Field2) X >ON Tab1.PK = X.MinPKYou can make a sort of PK - two fields together
select cast(sys(2007, F5, 0, 1) as B(0)) as PartOne, ; padr(F5, 200) as PartTwo, ; count(*) ; from test ; group by 1, 2