Hi,
Having a table with some duplicate ID's (different data tho), how can I
return the list but with only one record from each ID? Would this be using
the first() function and grouping?
Also, how would I choose which would be the first to be picked? If I did an
order by xx, would this alter the results, or is the first record picked
before the ordering is done?
Cheers,
Chris
Having a table with some duplicate ID's (different data tho), how can I
return the list but with only one record from each ID? Would this be using
the first() function and grouping?
Also, how would I choose which would be the first to be picked? If I did an
order by xx, would this alter the results, or is the first record picked
before the ordering is done?
Cheers,
Chris
Comment