In this example, the value supplied as input contains a single quotation mark, and therefore must be escaped by prefacing it with another single quotation mark. SELECT (SELECT 'Women''s Mountain Shorts' as ) AS ) AS t SELECT Predict (., INCLUDE_STATISTICS, 10) To understand how BottomPercent works, it may be helpful to first execute a prediction query that returns only the nested table. The following example creates a prediction query against the Association model that you built in the Basic Data Mining Tutorial. BottomPercent returns the smallest number of elements possible while still meeting the specified percent value. The rank is based on the evaluated value of the argument for each row, such that the sum of the values is at least the given percentage that is specified by the argument. The BottomPercent function returns the bottom-most rows in increasing order of rank. The name of a nested table column or table-valued expression.Ī column in the nested table, or expression that evaluates to a column.Ī double that indicates the total target percentage. Returns, in order of increasing rank, the bottom-most rows of a table whose cumulative total is at least a specified percentage.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |