SELECT MAX([created,jobId])[1] AS jobId
FROM default WHERE .. GROUP BY jobGroup, region;
1 Like
SELECT MAX([created,jobId])[1] AS jobId
FROM default WHERE .. GROUP BY jobGroup, region;