public virtual Task<IEnumerable<InvocationState>> GetLatestByJob() { return ConnectAndQuery(@" WITH cte AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY Job ORDER BY [UpdatedAt] DESC) AS rn FROM [work].Invocations ) SELECT * FROM cte WHERE rn = 1"); }