SUM of only TOP 10 rows

sql sum top-n
Cfw412 picture Cfw412 · Feb 12, 2015 · Viewed 30.6k times · Source

I have a query where I am only selecting the TOP 10 rows, but I have a SUM function in there that is still taking the sum of all the rows (disregarding the TOP 10). How do I get the total of only the top 10 rows? Here is my SUM function :

SUM( fact.Purchase_Total_Amount) Total

Answer

Maciej Los picture Maciej Los · Feb 12, 2015

Have you tried to use something like this:

SELECT SUM(Whatever)
FROM (
    SELECT TOP(10) Whatever
    FROM TableName
) AS T

Related questions

SUM of grouped COUNT in SQL Query

I have a table with 2 fields: ID Name -- ------- 1 Alpha 2 Beta 3 Beta 4 Beta 5 Charlie 6 Charlie I want to group them by name, with 'count', and a row 'SUM' Name Count ------- ----- Alpha 1 Beta 3 Charlie 2 SUM 6 How would I …

Read More
SQL not a single-group group function

When I run the following SQL statement: SELECT MAX(SUM(TIME)) FROM downloads GROUP BY SSN It returns the maximum sum value of downloads by a customer, however if I try to find the social security number that that max …

Read More
How can I use SUM() OVER()

I can't understand this code's bug ID AccountID Quantity 1 1 10 Sum = 10 2 1 5 = 10 + 5 = 15 3 1 2 = 10 + 5 + 2 = 17 4 2 7 = 7 5 2 3 = 7 + 3 = 10 SELECT ID, AccountID, Quantity, SUM(Quantity) OVER (PARTITION BY AccountID ) AS TopBorcT, FROM tCariH

Read More