I guess this is more faster:
SELECT T1.Field1, SUM(T2.Field1) FROM [Table] T1, [Table] T2 WHERE T1.Field1 >= T2.Field1 GROUP BY T1.Field1
This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
General News Suggestion Question Bug Answer Joke Praise Rant Admin
Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.