일별,주별,월별 통계
-- 일단위Select DATEPART(dd, order_dt), count(order_no) From 주문테이블group by DATEPART(dd, order_dt)order by DATEPART(dd, order_dt) -- 주 단위Select DATEPART(ww, order_dt), count(order_no) From 주문테이블group by DATEPART(ww, order_dt)order by DATEPART(ww, order_dt) -- 월단위Select DATEPART(mm, order_dt), count(order_no) From 주문테이블group by DATEPART(mm, order_dt)order by DATEPART(mm, order_dt) -- 년단위Select DATEPA..
2013. 4. 24.