loading unique values of a field

[#1]

hi all,

how can i load a table data against the unique values of a particular field of the table.

i.e. load table party_m with only that data which contains unique values of field party_code

[rbecher]

You can load all distinct party_code values first:

dist_code:
load distinct party_code from party_m;

...and then load all rows where exists party_code:

party_m:
load * from party_m where exists(party_code);

- Ralf

[rbecher]

I got it wrong in the first place.

dist_code:
load party_code where cnt = 1;
load party_code, count(party_code) as cnt from patry_m group by party_code;

Hope this helps.