Forum Discussion
summarize table by max date
Hi All, I have two tables, date table and invoice table. my requirement is to show the unique recent invoice data by refreshed date. if i put week column from date table it has to show the uniqu...
| week | Invoice | Invoice refresh date | max refresh date |
| WKS 01st Apr 2024 | 1111 | 4/5/2024 | John |
| WKS 01st Apr 2024 | 2222 | 4/5/2024 | Peter |
| WKS 01st Apr 2024 | 3333 | 4/5/2024 | Charles |
| WKS 01st Apr 2024 | 4444 | 4/5/2024 | Cathy |
| WKS 08th Apr 2024 | 1111 | 4/8/2024 | John |
| WKS 08th Apr 2024 | 2222 | 4/8/2024 | Peter |
| WKS 08th Apr 2024 | 3333 | 4/8/2024 | Charles |
| WKS 08th Apr 2024 | 4444 | 4/8/2024 | Cathy |
| WKS 22nd Apr 2024 | 1111 | 4/22/2024 | John |
| WKS 22nd Apr 2024 | 2222 | 4/22/2024 | Peter |
| WKS 22nd Apr 2024 | 3333 | 4/22/2024 | Charles |
| WKS 22nd Apr 2024 | 4444 | 4/22/2024 | Cathy |
| Month | Invoice | Refresh Date | Name |
Apr'24 | 1111 | 4/22/2024 | John |
| Apr'24 | 2222 | 4/22/2024 | Peter |
| Apr'24 | 3333 | 4/22/2024 | Charles |
| Apr'24 | 4444 | 4/22/2024 | Cathy |