심재운 블로그

728x90
반응형




-- 주 단위

Select DATEPART(ww, dates), count(order_no) From 테이블

group by DATEPART(ww, dates)

order by DATEPART(ww, dates)


 


-- 월단위

Select DATEPART(mm, dates), count(order_no) From tables

group by DATEPART(mm, dates)

order by DATEPART(mm, dates)


 


-- 년단위

Select DATEPART(yy, dates), count(order_no) From tables

group by DATEPART(yy, dates)

order by DATEPART(yy, dates) 





--분기별

SELECT A.memyear,A.AA,SUM(A.CNT) AS CNT

FROM ( 

Select DATEPART(yy, dates) as memyear,DATEPART(mm, dates) as memmonth,  count(dates) as cnt

,(CASE DATEPART(mm, dates) WHEN '1' THEN '1' WHEN '2' THEN '1' WHEN '3' THEN '1' 

WHEN '4' THEN '2' WHEN '5' THEN '2' WHEN '6' THEN '2' 

WHEN '7' THEN '3' WHEN '8' THEN '3' WHEN '9' THEN '3' 

WHEN '10' THEN '4'

WHEN '11' THEN '4'

WHEN '12' THEN '4' ELSE '0' END) AS AA

From Tables

group by DATEPART(mm, dates),DATEPART(yy, dates)

--order by DATEPART(ww, dates) 

) A

group by A.memyear,A.AA

order by A.memyear,A.AA


728x90
반응형
TAG : ,

공유하기

facebook twitter kakaoTalk kakaostory naver band

본문과 관련 있는 내용으로 댓글을 남겨주시면 감사하겠습니다.

비밀글모드

  1. 좋은정보 감사합니다. 예제가...
    2012.08.13 15:55
  2. 관람자
    -- 분기별
    select DATEPART(QUARTER,GETDATE())
    2017.08.16 17:07
loading