SELECT FROM <model> (DMX)
Performs an empty prediction join, returning the most probable value or values for the specified columns. Only the content from the mining model is used to create the prediction.
- expression list
A comma-separated list of expressions, or of predict or predict only columns.
Optional. An integer that specifies how many rows to return.
A model identifier.
- condition list
Optional. Conditions to restrict the values that are returned from the column list.
Optional. An expression that returns a scalar value.
The following example performs an empty prediction join on the Bike Buyer column, returning the most likely state in the TM Naive Bayes mining model.
SELECT ([Bike Buyer]) FROM [TM_Naive_Bayes]
The following example performs a prediction on the Amount column in the Forecasting model, returning the next four time steps. The Model Region column combines bike models and regions into a single identifier. The query uses the PredictTimeSeries function to perform the prediction.
SELECT [Model Region], PredictTimeSeries(Amount, 4) FROM Forecasting