T-SQL在时间间隔内计数并找到最高频率

CREATE TABLE #temp (
    timestamp DATETIME,
    count INT
);

INSERT INTO #temp
SELECT DATEADD(minute, DATEDIFF(minute, 0, YourTimestampColumn) / TimeInterval * TimeInterval, 0) AS timestamp,
       COUNT(*) AS count
FROM YourTable
GROUP BY DATEADD(minute, DATEDIFF(minute, 0, YourTimestampColumn) / TimeInterval * TimeInterval, 0);

SELECT t.YourTimestampColumn, t.OtherColumns
FROM YourTable t
INNER JOIN (
    SELECT TOP 1 timestamp
    FROM #temp
    ORDER BY count DESC
) t2 ON t.YourTimestampColumn >= t2.timestamp AND t.YourTimestampColumn < DATEADD(minute, TimeInterval, t2.timestamp);