Re: [sqlite] Deleting with offset when grouping

> Von: Patrik Nilsson [mailto:nipatriknils...@gmail.com] > Gesendet: Mittwoch, 22. Mai 2013 10:48 > An: General Discussion of SQLite Database > Betreff: [sqlite] Deleting with offset when grouping > > Hi All, > > I can't figure out how to delete with offset using groups. >

Re: [sqlite] Deleting with offset when grouping

SQLite Database Betreff: [sqlite] Deleting with offset when grouping Hi All, I can't figure out how to delete with offset using groups. Imagine I have a table create table history(id integer, lastactivity datetime default (datetime('now'))) and I insert values as insert into histo

[sqlite] Deleting with offset when grouping

Hi All, I can't figure out how to delete with offset using groups. Imagine I have a table create table history(id integer, lastactivity datetime default (datetime('now'))) and I insert values as insert into history (id) values (1) A resulting table might look 1|2013-05-22 07:50:05 1|2013-05-2