>Hi Sergey,
>
>>You want to retrive 2 records, one for EmpPK = 00001 and second for 00002, right?.
> Right.
>
>>The question is from which record should fld1 and fld2 come from for each of those keys?
> I don't care, any one will do because either:
> 1. I know that all the values of fld2 are identical for a given fld1 -or-
> 2. It doesn't matter which value of fld2 I get, any value is ok
>
>Thanks, Chaim
If you don't care, enclose fld1 and fld2 into MIN or MAX SQL function.
SELECT EmpPK, MAX(fld1), MAX(fld2) ;
FROM mytable ;
GROUP BY 1
--sb--