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
[email protected] 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
