I have this DMX query, which is written for Neural network model:
select t.*, predict ([module])
as [probability] from [Neuronske mreže]
prediction join openquery ([moodle baza],
'select distinct Course from [dbo].[log] ')
as t on [Neuronske mreže].[Course]=t.Course
order by PredictProbability([Module]) desc
And I get results, but just one Module for one Course. Even if I remove "distinct", results show more same results for one course.
Course Predicted Value Probability
32 Forum 95%
But, on the course 32 there are more Predicted values, and I want to show them all, with their probability.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.