Example: Sales by Quarter - Analytics Database - Teradata Vantage

The following example shows how sales are calculated by quarter for each business calendar setting.

SEL QuarterNumber_Of_Year(Sale_Date) Quarter_No,
Item_Code, SUM(Sale_Amt) FROM Sales_Tbl
GROUP BY 1,2
ORDER BY 1,2;
SET SESSION calendar = ISO;

SET SESSION calendar = Teradata;

SET SESSION calendar = COMPATIBLE;