我正在使用 MySQL 資料庫，我正在嘗試按周對結果進行分組，我知道如何按 DAY 或 MONTH 或 YEAR 進行分組，但不能按周分組，這是我的查詢：
SELECT DATE_FORMAT(Builds.date,"%y-%m-%d") as date, Labels.label_name
FROM Builds JOIN Labels ON Builds.Labels_label_id = Labels.label_id
GROUP BY MONTH(date)
謝謝你的幫忙。
uj5u.com熱心網友回復：
SELECT YEAR(Builds.date), WEEKOFYEAR(Builds.date) , Labels.label_name
FROM Builds JOIN Labels ON Builds.Labels_label_id = Labels.label_id
GROUP BY YEAR(Builds.date), WEEKOFYEAR(Builds.date);
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/458874.html
上一篇：從包含XML的列中獲取值