PostgreSQL:運行查詢“按分鐘”的行數我需要為每分鐘查詢到該分鐘的行總數。到目前為止,我所能達到的最好成績并不能做到這一點。它返回每分鐘的計數,而不是每分鐘的總計數:SELECT COUNT(id) AS count
, EXTRACT(hour from "when") AS hour
, EXTRACT(minute from "when") AS minute
FROM mytable GROUP BY hour, minute
PostgreSQL:運行查詢“按分鐘”的行數
慕慕森
2019-07-15 16:44:20