How to get sum of all max column value

how to use max and sum together in sql
how to use max and sum together in mysql
sql max(sum group by)
max(sum()) sql
rails sum multiple columns
matrix maximum column sum in c
rails sum column values
sum all values rails

I have an issue get cate and point below.

This is table query

-------------------------------------------
id    title    cate    query_id    point   |
-------------------------------------------
1     A        1       1           1       |
2     B        1       1           3       |
3     C        1       1           2       |
4     A        2       2           3       |
5     B        2       2           2       |
6     C        1       2           1       |
--------------------------------------------

If I groupby(cate, query) and get max point

----------------------------
cate    query_id    point   |
----------------------------
1       1           3       |
2       2           3       |
1       2           1       |
----------------------------

but I want to get sum of max poin by cate like this:

--------------
cate    point |
--------------
1         4   | 
2         3   |
--------------

I hope you could help me.

You can make an aggregate of an aggregate using a derived-table subquery like this:

SELECT cate, SUM(point) AS point
FROM (
    SELECT cate, query_id, MAX(point) AS point
    FROM MyTable
    GROUP BY cate, query_id
) AS t
GROUP BY cate;

Solved: sum of max values, Although, the minimum value for C�rdoba (500) it should not be considered in the sum. Is there any expression for this? Thanks! Solved! Go to� Maximum sum of a Matrix where each value is from a unique row and column Replace every matrix element with maximum of GCD of row or column Check whether row or column swaps produce maximum size binary sub-matrix with all 1s

with this you get the desired result

query::groupBy(cate,query_id)->sum(point)

Why MAX() of SUM() giving wrong output?, A column values that is used in the group by clause is the same for all rows in to sub-query in your answer ,in cross join's sub-select just get the max summed� If you already have a standard measure to sum your amount column, i.e., SUM (Table1 [Amount]), you can also use WeeklyMax = MAXX (VALUES (Table1 [Week Commencing]), [SumAmount]) This will return 60 in the totals row or when you have multiple weeks in one evaluation, but will return the week's sum otherwise. View solution in original post

First, you need to use group by(cate, query) and get cate,query_id,max(point).

SELECT cate, query_id, MAX(point) AS point
FROM demo
GROUP BY cate, query_id

demo on dbFiddle

Now You want to get sum of point group by cate from the above query output.

SELECT p.cate, SUM(p.point) AS point
FROM (
    SELECT cate, query_id, MAX(point) AS point
    FROM demo
    GROUP BY cate, query_id
) AS p
GROUP BY cate;

demo on dbfiddle

Find column with maximum sum in a Matrix, That is the column whose sum of elements are maximum. Examples: Input : mat[][ ] Function to find the column with max sum. pair< int , int >� @KHorseman Is late that is why you probably missed it..Wrap MAX() with calculate . Sum of Max = SUMX ( VALUES ( TableName[City] ); CALCULATE ( MAX ( TableName[Sales] ) ) ) On the Total ( no city filters) it sums 3 times the MAX of all table 3x3000

ActiveRecord::Calculations, This calculates aggregate values in the given column. Methods for count , sum , average , minimum , and maximum have been added as shortcuts. Person. calculate(:count, :all) # The same as Person.count Person.average(:age) # SELECT� Using your existing query as a subquery would be one way: SELECT SUM(maxpostmetric) FROM ( SELECT post_metrics.post_id, post_metric_types.name, MAX(post_metrics.value) maxpostmetric FROM post_metrics INNER JOIN post_metric_types ON post_metric_types.id = post_metrics.post_metric_type_id LEFT JOIN posts ON posts.id = post_metrics.post_id WHERE post_metrics.post_metric_type_id = 2 AND posts

How to find the item with the largest sum in a table range?, To find the max value in a list of values is easy for most of Excel users, but have in every column, please try to use the Kutools for Excel's Select Cells With Max� The AVG () function returns the average value of a numeric column. The SUM () function returns the total sum of a numeric column.

SQLite MAX: Get the Maximum Value in a Set, MAX([ALL|DISTINCT] expression);. The expression can be a column of a table or an expression that consists of operands, which are the columns, and operators� Solved: I need a dax function that populates all Rows of column Top1 with the Max Value of sales. looking at the picture, i want 1423 in all rows.

Comments
  • I don't understand your expected output. Can you explain the logic behind it?
  • I added logic. Could you please help me.
  • Glad to help. Remember on Stack Overflow it is custom to upvote answers that helped you, and use the green checkmark for the answer that solved your problem in the best way.