[Solved] How to find max fo each datacenter [closed]


Perhaps something like this

select region
,datacenter
,suite
,max(date1) over(partition by region) as max_date1
,max(date2) over(partition by region) as max_date2
from your_table;

6

solved How to find max fo each datacenter [closed]