If data looks like in Sample 1 than SELECT DISTINCT EmpPK, fld1, fld2 will return one record per EmpPK. For the Sample 2 there will be multiple records per EmpPK.

>Hi Sergey,
>
>>It's possible only if the rest of the fields included in the query have the same value per EmpPK.
>
> Sorry, I do not understand what you mean by this, could you explain?
> Thanks, Chaim

* Example 1
EmpPK fld1 fld2
00001  AA   BB
00001  AA   BB
00001  AA   BB
00002  CC   DD
00002  CC   DD
00002  CC   DD

* Example 2
EmpPK fld1 fld2
00001  AA   BB
00001  A1   BB
00001  AA   B2
00002  CC   DD
00002  C3   DD
00002  CC   D4