Mysql query to fetch sum from table

Question

I would like to perform mathematical operations along with fetching records from table.

Example : I have table with below data

| orderid | value | orderdate    |
 ----------------------------------
  1       | 100   |  2013-08-08  | 
  2       | 200   |  2013-08-05  | 
  3       | 300   |  2013-08-06  | 
  4       | 400   |  2013-08-09  |

And I am looking to sum(value) along with fetching all records from table. Example output

sum(value)| orderid | value | orderdate    |
 -------------------------------------------
  1000    | 1       | 100   |  2013-08-08  | 
  1000    | 2       | 200   |  2013-08-05  | 
  1000    | 3       | 300   |  2013-08-06  | 
  1000    | 4       | 400   |  2013-08-09  |

Please note 1000 is sum of value of all fetched records.

Kumar Soneta
– Kumar Soneta

2013-08-13 06:09:31 +00:00
Commented Aug 13, 2013 at 6:09 — Kumar Soneta
– Kumar Soneta, Commented Aug 13, 2013 at 6:09

John Woo · Accepted Answer · 2013-08-13 06:10:24Z

3

you can use CROSS JOIN.

SELECT  b.TotalValue, a.*
FROM    tableName a
        CROSS JOIN 
        (SELECT SUM(value) totalValue FROM tableName) b

or a correlated subquery,

SELECT  (SELECT SUM(value) FROM tableName) totalValue, 
        a.*
FROM    tableName a

answered Aug 13, 2013 at 6:10

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

Comments

Anurag · Accepted Answer · 2013-08-13 06:31:50Z

0

Try This

SELECT a.*,SUM(b.value) FROM tablename AS a,tablename AS b GROUP BY a.orderid

answered Aug 13, 2013 at 6:31

Anurag

1377 bronze badges

Collectives™ on Stack Overflow

Mysql query to fetch sum from table

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