Re: [sqlite] Subtotal SQL

On 29/07/2009 11:34 PM, Adler, Eliedaat wrote: > SQL/sqlite challenge for all: It would be helpful if you made it plain whether you are asking a trick question, or are a novice with a perceived problem (and whether the management is insisting that you absolutely must have an SQL-only solution

Re: [sqlite] Subtotal SQL

Adler, Eliedaat wrote: > I have a table with many columns describing objects on a disk. > >filename, date, owner, size >A12MO100 >B13 JAK90 >C10 MO80 >A13 LU 70 > > I have many different

Re: [sqlite] Subtotal SQL

On Wed, Jul 29, 2009 at 8:34 AM, Adler, Eliedaat wrote: > > SQL/sqlite challenge  for all: > > > I have a table with many columns describing objects on a disk. > >    filename, date, owner, size >    A            12    MO    100 >    B            13   JAK    90 >    C            10

Re: [sqlite] Subtotal SQL

Hello AE I have many different ways of ordering these objects. Usually using AE several sort parameters. I need a running sum of size that works AE regardless of what order the objects are in. I tried creating a UDF, but it seems that ordering is done after the unordered results have been

Re: [sqlite] Subtotal SQL

...@sqlite.org] On Behalf Of cmar...@unc.edu [cmar...@unc.edu] Sent: Wednesday, July 29, 2009 9:08 AM To: punk...@eidesis.org; General Discussion of SQLite Database Subject: Re: [sqlite] Subtotal SQL On Wed, 29 Jul 2009, P Kishor wrote: > For my part, I don't know how to do a running total in a res

Re: [sqlite] Subtotal SQL

On Wed, 29 Jul 2009, P Kishor wrote: For my part, I don't know how to do a running total in a result set unless I have some kind of a counter that keeps track of the "row before the current row" This is also the only way I know of. Chris On Wed, Jul 29, 2009 at 8:50 AM, Rich

Re: [sqlite] Subtotal SQL

On Wed, Jul 29, 2009 at 8:50 AM, Rich Shepard wrote: > On Wed, 29 Jul 2009, Adler, Eliedaat wrote: > >> SQL/sqlite challenge  for all: > >   No challenge for anyone who knows SQL. > >> I need a running sum of size that works regardless of what order the objects >> are

Re: [sqlite] Subtotal SQL

On Wed, 29 Jul 2009, Adler, Eliedaat wrote: > SQL/sqlite challenge for all: No challenge for anyone who knows SQL. > I need a running sum of size that works regardless of what order the objects > are in. > User Function/Aggregates welcome! _All_ implementations of SQL include a suite

[sqlite] Subtotal SQL

SQL/sqlite challenge for all: I have a table with many columns describing objects on a disk. filename, date, owner, size A12MO100 B13 JAK90 C10 MO80 A13 LU 70 I have many different ways of ordering