Competing solutions...gotta' love it...I prefer the postive solution as it's a list of what WILL be deleted. Though there's some merit in "tell me what will be left". delete from THI where ID in ( select t2.ID from THI t2 where t2.UserID=UserID order by t2.TimeStamp desc limit 1000000 offset 10); Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of Marcus Grimm Sent: Mon 1/17/2011 11:18 AM To: General Discussion of SQLite Database Subject: EXTERNAL:Re: [sqlite] Help on DELETE FROM... On 17.01.2011 17:26, Black, Michael (IS) wrote: > I came up with the logical opposite which I think does what you want > > select a.id from thi as a where a.id in (select thi.id from thi where > a.userid=thi.userid order by timestamp limit 1000000 offset 10); > > You just need to set the limit value to some ridiculous number. ahh... nice trick!! Thank you! ;) Hm.. but how do I place that into a "DELETE FROM ..." statement ? Here I can't use the alias syntax...
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users