Torna al Thread

SELECT Tabe.IDMezzo, Tabe.KmRif, Tabe.KmRif-Nz((SELECT Max(T.KmRif) FROM Tabe AS T WHERE ((T.IDMezzo = Tabe.IDMezzo) AND (T.KmRif < Tabe.KmRif))),0) AS Diff FROM Tabe ;
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5