Skip to content
Advertisement

How do I get the most recent processdate in a group?

I’m wanting to get the most recent entry per month using acct.processdate. I’ve tried using the MAX() function, but it doesn’t help since I am using group by. How do I go about doing this?

This is my current result:

enter image description here

This is my desired result:

enter image description here

New result with the CTE:

enter image description here

Advertisement

Answer

You can put your result in a cte and use not exists function

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement