How to fetch a specific value and sum of multiple values in MySQL

Question

I am facing a common problem in which, I want to fetch only single value from a field that are duplicates values and also get their sum value respectively.

For Example:

I just want to get sum of "profit" of particular year with their year label.

select year, sum(profit) as totalprofit from tablename group by year — Niraj patel
– Niraj patel, Commented Jun 9, 2017 at 9:31

Masivuye Cokile · Accepted Answer · 2017-06-09 09:32:15Z

5

Use group by to get the desired result

SELECT
    year,
    sum(PROFIT) 
FROM
    YOURTABLE 
GROUP BY
    year

edited Jun 9, 2017 at 9:32

Masivuye Cokile

4,7733 gold badges22 silver badges35 bronze badges

answered Jun 9, 2017 at 9:29

Arun Kumaresh

6,2966 gold badges36 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

How to fetch a specific value and sum of multiple values in MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related