SQL - sum of column

Question

I'm trying to create a SQL query that will sum column that have the same No_. How can I sum the Quantity?

select  Item.No_, Entry.[Posting Date], Entry.Quantity, MinMax.Maximum
FROM Item
 join Entry
 on Item.No_ = Entry.[Item No_]
 join MinMax
 on Item.No_ = MinMax.Item No_

The output:

but I want the output is sum of Quantity 10+5=15

Have you tried group by and sum()?

Andrey Korneyev
– Andrey Korneyev

2016-06-07 09:14:44 +00:00
Commented Jun 7, 2016 at 9:14 — Andrey Korneyev
– Andrey Korneyev, Commented Jun 7, 2016 at 9:14

Chris · Accepted Answer · 2016-06-07 09:17:28Z

1

Try the following although without test information the group by may not be correct/ work as expected.

select  Item.No_, Entry.[Posting Date], Sum(Entry.Quantity) as TotalQuantity, MinMax.Maximum
FROM Item
join Entry
on Item.No_ = Entry.[Item No_]
join MinMax
on Item.No_ = MinMax.Item No_
Group By Item.No_, Entry.[Posting Date], MinMax.Maximum

answered Jun 7, 2016 at 9:17

Chris

9358 silver badges28 bronze badges

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

Comments

Jeroen Bellemans · Accepted Answer · 2016-06-07 09:16:54Z

0

You can use the sum() function:

SELECT  sum(Entry.quantity) as sum_quantity
FROM Item
    JOIN Entry ON Item.No_ = Entry.[Item No_]
    JOIN MinMaxON Item.No_ = MinMax.Item No_

answered Jun 7, 2016 at 9:16

Jeroen Bellemans

2,0352 gold badges28 silver badges43 bronze badges

Collectives™ on Stack Overflow

SQL - sum of column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related