Create a Summarized report using Mysql Query

Question

My Table is like

| Cat | Sub_Cat | Amt|
______________________
 X    | Y       | 200
_______________________
 X    | Z       | 1000
__________________________
 X    | Y       | 300
__________________________
 A    | B       | 600

Now i want to write a query where i can Show a summarized report which is grouped by category like this output

| Cat | Sub_Cat | Amt|
______________________
 X    | Y       | 500
_______________________
 X    | Z       | 1000
__________________________
 A    | B       | 600

Kindly help

Stephan · Accepted Answer · 2013-09-17 12:16:04Z

2

Try this:

SELECT
  Cat,
  Sub_Cat,
  SUM(Amt) as total
FROM
  my_table
GROUP BY
  Cat,
  Sub_Cat

answered Sep 17, 2013 at 12:16

Stephan

8,1103 gold badges40 silver badges42 bronze badges

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

Comments

Michael Kazarian · Accepted Answer · 2013-09-17 12:22:00Z

2

select t.cat, t.sub_cat, sum(t.amt) from table t
group by t.cat, t.sub_cat

answered Sep 17, 2013 at 12:22

Michael Kazarian

4,4921 gold badge23 silver badges27 bronze badges

Collectives™ on Stack Overflow

Create a Summarized report using Mysql Query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related