distinct values

[kumariaru]

Hi All,
I like to retrieve data from db2 based on 4 columns which are keys..Something like this c1,C2,c3,C4 with distinct values of c4,c2.

I am trying
SELECT DISTINCT( C2,C4) ,C1,C2
FROM CRMADMIN.T_WHSE_PO_DTL
Group by C1,C2,C3,C4
;
I am not able to run it .. Any help is great

Thank you

 

[blom0344]

If C1,C2,C3,C4 is the unique key then getting all combinations of the 4 fields based on distinct C4,C2 will net you all unique combinations.
Can you rephrase what you really need , cause this is not making any sense...


Ties Blom