MySQL Forums
Forum List  »  MySQL Query Browser

Advanced Search
New Topic

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
country--i_data--o_data--Total
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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL query
Pramod Kumar
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.