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]
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]