Field: the client account, account for end, transaction date, transaction type (roll-in and roll-out), transaction data (1 million)

1, first find out no into account, is the primary account
2, starting from the first transfer deal of primary account,
On January 1, 2018, 12:50000
A to BAfter January 1, 2018, 12:50000
B to CBy analogy, where is the money to
3, tracking the appearance of the display is
Condensed into hundreds of thousands of pieces, like solitaire

CodePudding user response:

Connect by the prior start with recursive query under reference

CodePudding user response:

Recursive tree, start with connect by