例: 全四半期の第1週の平日累積売上げ - Teradataカレンダ - Advanced SQL Engine - Teradata Database

この例では、全四半期の第1週の平日における品目の累積売上げを検索します。

SET SESSION calendar = Teradata;
/* Setting SUNDAY and SATURDAY as weekend days. */
exec dbc.createbusinesscalendarpattern('teradata','SUNDAY','OFF',);
exec dbc.createbusinesscalendarpattern('teradata','SATURDAY','OFF',);
SEL Item_Code, SUM(Sale_Amt) FROM Sales_Tbl,
       Sys_Calendar.BusinessCalendar
WHERE WeekNumber_Of_Quarter(Sale_Date) = 1
AND calendar_date = Sale_Date
AND IsBusinessDay  = 1
GROUP BY Item_Code
ORDER BY 1;

SET SESSION calendar = Teradata;