SQL Sum Query issue

Question

I'm new to SQL Server and struggling with this.

I have two select statements

SELECT 
    SUM(Amount) AS "MONDAY" 
FROM 
    Transaction 
WHERE 
    Transaction_Date = '2015-12-21 00:00:00.000'

SELECT 
    SUM(Amount) AS "TUESDAY" 
FROM 
    Transaction 
WHERE 
    Transaction_Date = '2015-12-22 00:00:00.000'

Their result is 2,00,000 and 3,00,000 respectively

I want the output to be shown as two columns

(Column 1 + Monday) and (Column 2 = Tuesday) on SQL Server screen

sgeddes · Accepted Answer · 2016-06-28 19:34:09Z

6

One option is to use conditional aggregation for that:

SELECT SUM(CASE WHEN Transaction_Date = '2015-12-21 00:00:00.000'  
           THEN Amount END) AS "MONDAY" ,
       SUM(CASE WHEN Transaction_Date = '2015-12-22 00:00:00.000' 
           THEN Amount END) AS "TUESDAY" 
FROM Transaction

answered Jun 28, 2016 at 19:34

sgeddes

62.9k7 gold badges67 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ganders · Accepted Answer · 2016-06-28 19:36:13Z

1

select datepart(dw, transactiondate),
    sum(amount) [sum]
from transaction
where transaction_date between '2015-12-22' and '2015-12-23'
group by datepart(dayofweek, transactiondate)

keep in mind, this is pseudo-code, I'm looking up the "dayofweek" attribute...

Lookup datepart here: https://msdn.microsoft.com/en-us/library/ms174420.aspx

edited Jun 28, 2016 at 19:36

answered Jun 28, 2016 at 19:34

ganders

7,46018 gold badges74 silver badges117 bronze badges

1 Comment

sgeddes Over a year ago

Nice approach but this will create multiple results versus a single row with multiple columns...

Community · Accepted Answer · 2017-05-23 12:22:40Z

0

I think you need to use MSSQL Pivot function to transform rows into columns. Check this other question. Maybe this can help you: Convert Rows to columns using 'Pivot' in SQL Server

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Jun 28, 2016 at 19:42

Waldir J. Pereira Junior

8261 gold badge10 silver badges18 bronze badges

Collectives™ on Stack Overflow

SQL Sum Query issue

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related