Trebalo bi da može i ovako (TSQL):
Kôd:
SELECT
DATEPART(HH, TimeColumn) AS Hour,
MAX(X) as MaxX
FROM
[Table]
WHERE
TimeColumn > DATEADD(DD, -1, GETDATE())
GROUP BY
DATEPART(HH, TimeColumn)
Ako je bitan i redosled, kad kreće od 16 sati, da ide redom 16,17... pa sledeći dan, onda može ovako:
Kôd:
SELECT
MAX(DATEPART(DD, TimeColumn)) AS Day,
DATEPART(HH, TimeColumn) AS Hour,
MAX(X) as MaxX
FROM
[Table]
WHERE
TimeColumn > DATEADD(DD, -1, GETDATE())
GROUP BY
DATEPART(HH, TimeColumn)
ORDER BY
Day, Hour