Hi everyone - so I have a table that I'm trying to query against to produce certain results. I'm having a bit of trouble so I'm not clear about the right solution.
Here is my table:
Cust ID As of Month-Year Amt Period XYZ-001 1-OCT-18 .0860 4Q 2018 XYZ-001 1-NOV-18 .0839 4Q 2018 XYZ-001 1-DEC-18 .0719 4Q 2018 XYZ-001 1-JAN-19 .0711 1Q 2019 XYZ-001 1-FEB-19 .1040 1Q 2019 XYZ-001 1-MAR-19 .1161 1Q 2019
What I'm attempting to do is show the last Amt for each period. So if I was able to get the results I'm looking for, it would like this:
Cust ID As of Month-Year Amt Period XYZ-001 1-DEC-18 .0719 4Q 2018 XYZ-001 1-MAR-19 .1161 1Q 2019
Can anyone help me with this solution?
Thank you.