카테고리 없음 잘생긴팝콘 2017. 3. 29. 11:13
출처 : http://www.gurubee.net/article/65315 SELECT ym , MIN(CASE dw WHEN 1 THEN d END) Sun , MIN(CASE dw WHEN 2 THEN d END) Mon , MIN(CASE dw WHEN 3 THEN d END) Tue , MIN(CASE dw WHEN 4 THEN d END) Wed , MIN(CASE dw WHEN 5 THEN d END) Thu , MIN(CASE dw WHEN 6 THEN d END) Fri , MIN(CASE dw WHEN 7 THEN d END) Sat FROM (SELECT date_format(dt,'%Y%m') ym , Week(dt) w , Day(dt) d , DayofWeek(dt) dw FROM..
더 읽기