Re: [sqlite] Removing duplicate records

2009-02-23 Thread Igor Tandetnik
"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 >>

Re: [sqlite] Removing duplicate records

2009-02-23 Thread Igor Tandetnik
"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

Re: [sqlite] Removing duplicate records

2009-02-23 Thread Lawrence Chitty
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

[sqlite] Removing duplicate records

2009-02-23 Thread Gary O'Brien
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