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
;