Select Max Date from these temp table

Select Max Date from this below temp table.

SELECT ORDER_DETAIL_MARKET_CODE, NEW_OPER, MAX(ACTIVITY_DATE)
from #final
GROUP BY ORDER_DETAIL_MARKET_CODE, NEW_OPER
ORDER BY ORDER_DETAIL_MARKET_CODE

What's the problem?

1 Like

I got it. I am just trying to get max date for each user.