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 ?

Imbue · Accepted Answer · 2013-11-14 20:08:05Z

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

answered Nov 14, 2013 at 20:02

Imbue

4294 silver badges15 bronze badges

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

Comments

fthiella · Accepted Answer · 2013-11-14 20:08:05Z

1

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

answered Nov 14, 2013 at 20:08

fthiella

49.2k15 gold badges96 silver badges108 bronze badges