Glossary

14. B

ROW_NUMBER() assigns sequential integers starting at 1 within each partition. PARTITION BY ACCT_NUM creates a separate sequence for each account, ordered by TXN_DATE.

Learn More

Related Terms