[sqlite] Question on selecting rows of an arbitrary range

2004-09-13 Thread sankara . narayanan
Return Receipt Your [sqlite] Question on selecting rows of an arbitrary range document

[sqlite] Question on selecting rows of an arbitrary range

2004-09-13 Thread Ishwar . Jasuja
Return Receipt Your [sqlite] Question on selecting rows of an arbitrary range document

[sqlite] Question on selecting rows of an arbitrary range

2004-09-13 Thread Stephan Stapel
Hi there! In order to select a number of files that have about a certain size in sum, I tried to throw this query: select id, type, filename, filesize from diskcache_index a where (select sum(filesize) from diskcache_index b where a.id < b.id) < MYCLEANSIZE I'm doing this to find out a certain list