Histogram Example 2: AutoBin ('Scott') - Teradata Vantage

Input

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

SQL Call

DROP TABLE IF EXISTS cars_scott_out;

SELECT * FROM Histogram (
  ON cars_hist AS InputTable
  OUT TABLE OutputTable (cars_scott_out)
  USING       
  AutoBin ('Scott')
  TargetColumn ('hp')
) AS dt;

Output

This query returns the following table:

SELECT * FROM cars_scott_out ORDER BY 1;