sql语句从该类中推荐score比较高的@requireCount个资源

select Top (@requireCount) *
from dbo.RecommendationByCategoryID t
where t.categoryID=@categoryID
order by t.score DESC
END

转载于:https://blog.51cto.com/javaz/408590