Sum of values from two rows of a table into a view

Question

I have a SQL table which mentions stock quantity like this:

Tool: Stock
A: 100
A: 200
B: 50

I want to create a view where it will give me the following output, where it would count the sum of same tool numbers:

Tool: Stock
A: 300
B: 50

How to achieve this? Thanks in advance :)

Here are the resources to create view `https://www.w3schools.com/sql/sql_view.asp`, group by and sum `https://www.w3schools.com/sql/sql_groupby.asp` — Sowmyadhar Gourishetty, Aug 28 '20 at 16:39

Fahmi · Accepted Answer · 2020-08-28T16:45:25.237

0

Try the below -

create view view_name as
    select tool, sum(stock)
    from tablename
    group by tool

edited Aug 28 '20 at 16:45

answered Aug 28 '20 at 16:38

Fahmi

1 Answers1