MySQL获取季度的开始和结束日期按季度

Question

$sq =" 
SELECT count(noofrows),QUARTER(Date(last_call)) as quarter,YEAR(last_call) 
FROM $dbt.travel_crm 
WHERE Date(last_call) BETWEEN '".$_GET['startdate']."' 
AND '".$_GET['enddate']."' 
GROUP BY QUARTER(Date(last_call)) 
ORDER BY YEAR(last_call)"; 

只给当前年份行数，bcoz按季度分组，我需要按(quarter,year)分组，如何做到这一点？

Answer 1

如果您需要按季度和年度 - 只是这样做：

GROUP BY YEAR(last_call), QUARTER(last_call)