mysql 년, 월 복합 데이터 쿼리 작성 참고
Linux/MySql : 2009/01/07 18:49
원문 : http://database.sarang.net/?inc=read&aid=27949&criteria=mysql&subcrit=&id=&limit=20&keyword=&page=1
SELECT
f_id,
SUM(if(f_date BETWEEN '2009-01-01' AND '2009-12-31', f_value, 0)) AS year_value,
SUM(if(f_date BETWEEN '2009-03-01' AND '2009-03-31', f_value, 0)) AS month_value
FROM
a
GROUP BY f_id
ORDER BY month_value
TAG MySql
Trackback Address :: http://jjangu.pe.kr/blog/trackback/539
