Add same values in mysql with two parameters sql

Question

I have a table trade as follows:-

bm  | m   | price | amount | total    | status
USD | BTC | 0.01  | 1      | 0.01     | active
USD | BTC | 0.01  | 2.5    | 0.025    | active
USD | BTC | 0.4   | 0.5    | 0.020    | active 
USD | BTC | 0.4   | 0.22   | 0.088    | active

I want to add amounts of duplicate price i.e 0.01 and 0.4 as well as total together in one output where status is active and show them so that the result is like:-

price | amount  | total
0.01  | 3.5     | 0.035
0.4   | 0.722   | 0.108

Mureinik · Accepted Answer · 2018-09-07 14:03:34Z

2

You could group according to the price and sum the other columns:

SELECT   price, SUM(amount), SUM(total)
FROM     trade
WHERE    status = 'active'
GROUP BY price

edited Sep 7, 2018 at 14:03

answered Sep 7, 2018 at 14:00

Mureinik

316k54 gold badges400 silver badges405 bronze badges

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

3 Comments

JeffB Over a year ago

Is there a way to remove the comma , from the result?

Mureinik Over a year ago

@JeffB what comma?

JeffB Over a year ago

Let's say result is 7,000 ... but i want result to be only 7000 without comma ,

ScaisEdge · Accepted Answer · 2018-09-07 14:02:39Z

1

you could use aggregation function sum() and group by price

select   , price , sum(amount) , sum(total) 
from my_table  
group by   price

answered Sep 7, 2018 at 14:02

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

1 Comment

JeffB Over a year ago

Is there a way to remove the comma , from the result?

Fahmi · Accepted Answer · 2018-09-07 14:05:39Z

1

try this with group by:

select price, sum(amount) as amount,sum(total) as total
from tablename where status='active'
group by price

edited Sep 7, 2018 at 14:05

answered Sep 7, 2018 at 14:00

Fahmi

37.5k5 gold badges26 silver badges32 bronze badges

2 Comments

JeffB Over a year ago

Is there a way to remove the comma , from the result?

JeffB Over a year ago

Lets say result is 7,000.00 ...I want only 7000 without comma

Sebastian Farias · Accepted Answer · 2018-09-07 14:18:52Z

1

you can try something like this:

SELECT *, sum(amount) AS totalAmount,sum(total) AS total 
FROM TABLE_NAME 
GROUP BY price;

edited Sep 7, 2018 at 14:18

answered Sep 7, 2018 at 14:14

Sebastian Farias

5134 silver badges6 bronze badges

3 Comments

JeffB Over a year ago

Is there a way to remove the comma , from the result?

Auspex Over a year ago

You can't use * for this query in any flavour of SQL I know. You are returning bm and m which are not aggregated. You could either specify price instead of * or group by bm, m, price

JeffB Over a year ago

Lets say result is 7,000.00 ...I want only 7000 without comma

Collectives™ on Stack Overflow

Add same values in mysql with two parameters sql

4 Answers 4

3 Comments

1 Comment

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related