Select non-group by fields using sql query

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