통계 – AuctionPro

월별 티켓 개수 합 MS SQL Query

2012년 09월 07일 golgol 0

월별 티켓 개수 합 MS SQL Query


SELECT DATEPART(yyyy,Issue_Date) AS Year
,MAX(DATENAME(mm,Issue_Date)) AS  Month
,MAX(DATENAME(dd,Issue_Date)) AS  DATE
,SUM(COALESCE(GO_TKTCNT,0)) AS  TICKET
FROM [dbo].[FF_DB]
where  Regi_Date&gt;'2013-01-01'
GROUP BY DATEPART(yyyy,Issue_Date),
DATEPART(mm,Issue_Date),
DATEPART(dd,Issue_Date)
ORDER BY DATEPART(yyyy,Issue_Date),DATEPART(mm,Issue_Date)

SELECT DATEPART(yyyy,Issue_Date) AS Year

,MAX(DATENAME(mm,Issue_Date)) AS Month

,MAX(DATENAME(dd,Issue_Date)) AS DATE

,SUM(COALESCE(GO_TKTCNT,0)) AS TICKET

FROM [dbo].[FF_DB]

where Regi_Date>'2013-01-01'

GROUP BY DATEPART(yyyy,Issue_Date),

DATEPART(mm,Issue_Date),

DATEPART(dd,Issue_Date)

ORDER BY DATEPART(yyyy,Issue_Date),DATEPART(mm,Issue_Date)