NuGet.Services.Work.InvocationQueue.GetLatestByJob C# (CSharp) Метод

        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");
        }