MySQL Forums
Forum List  »  MySQL Query Browser

MySQL query
Posted by: Pramod Kumar
Date: March 01, 2016 06:36AM

my MySQL table is like
Country--data -- io
AU -- 25 --i_data
AU -- 60 --o_data
IN -- 56 --i_data
IN -- 44 --o_data

the output required in a query is
AU -- 25 -- 60 -- 85
IN -- 56 -- 44 -- 100

total data is sum of i_data + o_data and it is grouped by country
is this possible

Options: ReplyQuote

Written By
MySQL query
March 01, 2016 06:36AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.