Torna al Thread

SELECT G01.Contatore, Tabx.Data, Tabx.Ruota, Tabx.Primo, Tabx.Secondo, Tabx.Terzo, Tabx.Quarto, Tabx.Quinto FROM Tabx INNER JOIN ( SELECT DISTINCT TabY.Data, nz((SELECT DISTINCT SUM(1) AS xx FROM (SELECT DISTINCT Tabx.Data FROM Tabx) AS TabZ WHERE TabZ.Data>TabY.Data ),0)+1 AS Contatore FROM Tabx AS TabY ) AS G01 ON Tabx.Data = G01.Data ORDER BY Tabx.Data DESC ;
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5