MySQL Select Multiple Columns And a SUM column

Question

Lets says I got a table like this -

 id  |  name  |  salary
 01  |  ABCD  |  1000
 02  |  EFGH  |  2000    
 03  |  IJKL  |  3000

Now is it possible to get result set like this?

id  |  name  |  salary | SUM
01  |  ABCD  |  1000   | 6000
02  |  EFGH  |  2000
03  |  IJKL  |  3000

I tried SELECT id, name, salary, SUM(salary) FROM table but it just gives me one row. Is there any way to get all the rows with an extra column ?

Duplicate of http://stackoverflow.com/questions/2563918/create-a-cumulative-sum-column-in-mysql — Peter van der Wal, Nov 14 '13 at 20:02

Imbue · Accepted Answer · 2013-11-14T20:08:05.687

1

Try:

SELECT id, name, salary, SUM(salary) AS sum FROM table

EDIT: Think i misunderstood. Maybe this is what you're looking for:

SELECT id, name, salary (SELECT SUM(salary) FROM table) AS sum FROM table

edited Nov 14 '13 at 20:08

answered Nov 14 '13 at 20:02

Imbue

score 1 · Answer 2 · answered Nov 14 '13 at 20:08

1

SELECT
  id,
  name,
  salary,
  (SELECT SUM(salary) FROM table)
FROM
  table

answered Nov 14 '13 at 20:08

fthiella

2 Answers2