[ACCEPTED]-SQL sum( ) over different periods?-aggregate

Accepted answer

Score: 10

SELECT  SUM(CASE WHEN TradeDate BETWEEN '2004-01-01' AND '2010-08-31' THEN Amount END),
        SUM(CASE WHEN TradeDate BETWEEN '2006-01-01' AND '2010-08-31' THEN Amount END),
        SUM(CASE WHEN TradeDate BETWEEN '2010-01-01' AND '2010-08-31' THEN Amount END)
FROM    Funds
JOIN    Cashflow
ON      Cashflow.id = Funds.id

0

Score: 1

Use group by:

select period, sum(money) from table group by period

0

Source: stackoverflow.com

More Related questions

There is already an object named '##Temp' in the database

Create foreign key without checking existing data

SQL Server ROW_NUMBER() on SQL Server 2000?

Inserting n number of records with T-SQL

What causes SQL Server to return the message 'The statement has been terminated'?

sql: aggregate functions & string join / concatenation

Performance of COUNT SQL function

SQL distinct and count

Using MYSQL GROUP_CONCAT in the WHERE clause

Aggregate Function on Uniqueidentifier (GUID)

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.