SQL-Server

Query for running total in SQL Server

iamalik

Rate me:

Please Sign up or sign in to vote.

5.00/5 (1 vote)

25 Aug 2011CPOL 9.1K   1   1

I guess this is more faster:SELECT T1.Field1, SUM(T2.Field1) FROM [Table] T1, [Table] T2WHERE T1.Field1 >= T2.Field1GROUP BY T1.Field1

I guess this is more faster:

SQL

SELECT T1.Field1, SUM(T2.Field1)  
FROM [Table] T1, [Table] T2
WHERE T1.Field1 >= T2.Field1
GROUP BY T1.Field1

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

iamalik

Chief Technology Officer IntegCubes

 Pakistan

More than 18 years of experience in software development. Worked on various project in different phases.

Comments and Discussions

First Prev Next

Reason for my vote of 5 Works just fine. And subqueries rea... smcnulty20006-Sep-11 21:41 smcnulty2000 6-Sep-11 21:41  Reason for my vote of 5 Works just fine. And subqueries really do often have speed issues in t-sql.

Last Visit: 31-Dec-99 18:00     Last Update: 30-Apr-24 8:28 Refresh 1

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.