"Lawrence Chitty"
wrote in
message news:49a32a32.6040...@ntlworld.com
> Gary O'Brien wrote:
>> Given the following table and data, I'd like to remove
>> all items with duplicate types within a container,
>> keeping the most recent (largest item_id) item of that
>>
"Gary O'Brien" wrote in message
news:93fda2e5d3cb442884be95e1b84fc...@garysldc13y00e
> Given the following table and data, I'd like to remove
> all items with duplicate types within a container,
> keeping the most recent (largest item_id) item of that
> type within each
Gary O'Brien wrote:
> Greetings,
>
> I'd like to know if anyone has an elegant solution to
> the problem stated below. I know it could be brute
> forced but it seems that there should be an elegant
> SQL solution to this problem.
>
> Given the following table and data, I'd like to remove
> all
Greetings,
I'd like to know if anyone has an elegant solution to
the problem stated below. I know it could be brute
forced but it seems that there should be an elegant
SQL solution to this problem.
Given the following table and data, I'd like to remove
all items with duplicate types within a
4 matches
Mail list logo