-1

So i'm a newbie at programming and i need to store data.I have created Service-Based Database for store the data and i have a table like this.

gameprice gamedesc gametotal
60 RDR2
40 R6S

I want to take gameprice column, sum it, and write to gametotal. I mean even if i add another game it will add new game price to current gametotal.

Select Sum(gameprice) as gametotal From gametable

like this

gameprice gamedesc gametotal
60 RDR2 100
40 R6S
gameprice gamedesc gametotal
60 RDR2 160
40 R6S
60 DyingL2
  • Can you give an example of the desired result? It's not clear to me. – johey Sep 02 '22 at 09:56
  • don't need gametotal column just run this query whenewer you need SELECT * FROM [YourTable] UNION ALL SELECT SUM(gameprice), 'Gametot' AS gamedesc FROM [YourTable] – Uday Dodiya Sep 02 '22 at 10:14

2 Answers2

0

Are you looking answer to be like below

gameprice gamedesc 40 R6S 60 RDR2 100 Gametot

If yes you can use below query

SELECT * FROM [YourTable] UNION ALL SELECT SUM(gameprice), 'Gametot' AS gamedesc FROM [YourTable]

Sreepathi
  • 93
  • 13
  • yes, like this but it will be much better if gametotal can be a column. –  Sep 02 '22 at 10:38
0
-- make gt variable
DECLARE @gt INT;

-- clear GameTotal Column 
UPDATE GameTable SET GameTotal = NULL 

-- set gt value to game column total value
select @gt = sum(game) from GameTable;

-- insert @gt to GameTotal Column
INSERT INTO GameTable (GameTotal) values (@gt);