"Gary O'Brien" <[email protected]> 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 container.
delete from item where exists (
select 1 from item item2
where item2.container_id = item.container_id
and item2.type = item.type
and item2.item_id > item.item_id);
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
