Histogram Example 3: BinSize, StartValue, EndValue - Teradata Vantage

You specify one bin size and start and end values, and the output is grouped for each values of grouping variable (cyl).

Input

• InputTable: cars_hist, as in Histogram Example 1: AutoBin ('Sturges')

SQL Call

DROP TABLE IF EXISTS cars_hist_out;

SELECT * FROM Histogram (
  ON cars_hist AS InputTable
  OUT TABLE OutputTable (cars_hist_out)
  USING
  StartValue (20)
  BinSize (50)
  EndValue (400)
  Inclusion ('right')
  TargetColumn ('hp')
  GroupByColumns ('cyl')
) AS dt;

Output

This query returns the following table:

SELECT * FROM cars_hist_out ORDER BY 1;