MySQL Forums
Forum List  »  MySQL Workbench

help regarding a table
Posted by: Akash Kumar
Date: April 03, 2019 12:42AM

This is the table which has 1000 records but have mentioned only few of them .
utid date
'0', NULL
'6', '2016/05/25'
'15', '2016/06/10'
'3', '2016/07/20'
'15', '2016/07/21'
'18', '2016/08/23'
. .
. .
. .
utid = transaction id created on a particular date
date = transaction id created on a particular date
Now the desired i want is

utid date sumutid up to now

'0', NULL 0
'6', '2016/05/25' 6
'15', '2016/06/10' 21
'3', '2016/07/20' 24
'15', '2016/07/21' 39
'18', '2016/08/23' 57

version

MySQL Workbench Community (GPL) for Linux/Unix version 6.3.9 CE build 10690321 (64 bit)

Options: ReplyQuote


Subject
Views
Written By
Posted
help regarding a table
503
April 03, 2019 12:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.