Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Returns the probability that the input case belongs to the specified cluster.
The following syntax uses the mining model content schema rowset to return the node captions that exist in the mining model.
SELECT NODE_CAPTION FROM <model>.CONTENT
If a <node caption> is not specified, the function returns the probability that the input cases belong to the most likely cluster. Use the Cluster function to return the most likely cluster.
The following example returns the probability that the specified case exists in the cluster labeled Cluster 2.
SELECT ClusterProbability('Cluster 2') From [TM Clustering] NATURAL PREDICTION JOIN (SELECT 28 AS [Age], '2-5 Miles' AS [Commute Distance], 'Graduate Degree' AS [Education], 0 AS [Number Cars Owned], 0 AS [Number Children At Home]) AS t