[sqlite] Subtotal SQL

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   MO    80
    A            13   LU      70

I have many different ways of ordering these objects. Usually using several 
sort parameters.

I need a running sum of size that works regardless of what order the objects 
are in.

Sort by date,owner
Name     Size    Sum
C            80       80
A          100      180
B           90       270
A          70      340


Sort by filename, owner
Name     Size     Sum
A           70        70
A          100      170
B           90       260
C          80        340

User Function/Aggregates welcome!
thanks
Eliedaat Adler


________________________________
This message is confidential and intended only for the addressee. If you have 
received this message in error, please immediately notify the 
postmaster@xxxxxxx and delete it from your system as well as any copies. The 
content of e-mails as well as traffic data may be monitored by NDS for 
employment and security purposes.
To protect the environment please do not print this e-mail unless necessary.

An NDS Group Limited company. www.nds.com
_______________________________________________
sqlite-users mailing list
sqlite-users@xxxxxxxxxx
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users