MySQL Command Sum of Products Between Different Columns in Equal Columns

Asked 2 years ago, Updated 2 years ago, 63 views

|A|B|C 
|1|1|100 
|1|1|200 
|2|1|300 
|2|4|50 
|2|1|100 
|3|1|500

Suppose you have columns A, B, and C in a table with MySQL, and the values are similar to those above.

I'd like to extract the product of B and C of each row in a row where the value of A is equal, and the value of A is 500 or more, avoiding duplication. What kind of command would it be?

(Example)
If A is 1, 1*100+1*200=300
If A is 2, 1*300+4*50+1*100=600
If A is 3, 1*500=500
Therefore, 2 and 3 are acquired.

mysql sql

2022-09-30 21:13

1 Answers

There is no twist, but if you follow the question,

SELECTA
FROMT
GROUP BY A
HAVING 500<=SUM(B*C);


2022-09-30 21:13

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.