Support SIDU Page Chart Bank
Blog Home / SIDU

SQL row sum

2018-11-02 00:00
11936   0
MySQL, Test 
Given an SQL table

ID Amt
-- ---
1 100
2 200
3 300

Please write a MySQL statement to produce the following result:

ID Amt Total
-- --- -----
1  100 100
2  200 300
3  300 600

And here is an example SQL:

SELECT a.ID, a.Amt, sum(b.Amt) AS Total
FROM tab AS a
JOIN tab AS b ON a.ID >= b.ID
GROUP BY 1,2
Back « SIDU feature request and bug
Next » Wiki: Topnew DB helper

Leave a comment

Comments

Comment is closed

Category

Top Read

» How to install databases
» Godaddy Magic Quotes Problem
» Optional sidu_fk table
» Wiki: Topnew DB helper
» SIDU import/export data clean
» SIDU hotkey list
» SIDU SQL in charts: howto
» SIDU feature request and bug
» Localhost SIDU ssh connect remote site localhost
» SIDU Support and Help Desk

Top Tags

wiki, feature, bug, test, CMS, MySQL, blog, SIDU, forum, bank, ticket, news, PHP