Select Max of sum Value in mysql

Question

I have a table in my database like this :

m  | v
-------
1  | 10
1  | 15
1  | 15
2  | 8
2  | 12
2  | 14
3  | 25
3  | 15
3  | 18
4  | 12

I want select maximum of sum v group by m and in first step I create table with this code :

First Code:

select m,sum(v) as v from table group by m

First result:

m  | v
-------
1  | 35
2  | 34
3  | 54
4  | 12

and for select max in this table my code is :

Second Code:

select max(v) as v,m from 
  (select sum(v) as v,m from table group by `m`)ta

Second result:

v  | m
------
54 | 1

Correct result:

v  | m
------
54 | 3

i haven't any idea for solve this problem.

Aziz Shaikh · Accepted Answer · 2014-11-25 06:06:33Z

2

Try this:

select m,sum(v) as v from table group by m ORDER BY v DESC LIMIT 0,1

answered Nov 25, 2014 at 6:06

Aziz Shaikh

16.6k11 gold badges65 silver badges81 bronze badges

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

Comments

Girish · Accepted Answer · 2014-11-25 06:05:30Z

1

try this query

 SELECT v,m from 
  (SELECT SUM(v) as v, m FROM maxValues GROUP BY `m`) ta
ORDER BY v DESC
LIMIT 1

edited Nov 25, 2014 at 6:05

answered Nov 25, 2014 at 6:00

Girish

12.1k3 gold badges37 silver badges54 bronze badges

Comments

Junaid S. · Accepted Answer · 2014-11-25 06:02:16Z

0

try this

(select max(sum(v)), m as v,m from table group by `m`)

answered Nov 25, 2014 at 6:02

Junaid S.

2,6567 gold badges47 silver badges83 bronze badges

Collectives™ on Stack Overflow

Select Max of sum Value in mysql

First Code:

First result:

Second Code:

Second result:

Correct result:

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

First Code:

First result:

Second Code:

Second result:

Correct result:

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related