Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- CAST(t.AmountXRP / 1000000 AS INT64) AS AmountXRP,
- COUNT(*) AS COUNT
- FROM
- xrpledgerdata.fullhistory.transactions t
- JOIN
- xrpledgerdata.fullhistory.ledgers l
- ON
- t.LedgerIndex = l.LedgerIndex
- WHERE
- t.Account = 'rDsbeomae4FXwgQTJp9Rs64Qg9vDiTCdBv'
- AND
- t.AmountXRP IS NOT NULL
- AND
- t.TransactionType = 'Payment'
- AND
- t.Destination = 'rLSn6Z3T8uCxbcd1oxwfGQN1Fdn5CyGujK'
- AND
- t.DestinationTag = 96604252
- AND
- t.TransactionResult = 'tesSUCCESS'
- GROUP BY
- AmountXRP
- ORDER BY
- COUNT DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement