从投票人中随机抽取十个不重复的人
SQL:
SELECT WorkNO FROM [dbo].[T_Score] where VotingNum<>1 GROUP BY WorkNO ORDER BY NEWID();
积累小的知识,才能成就大的智慧,希望网上少一些复制多一些原创有用的答案
SQL:
SELECT WorkNO FROM [dbo].[T_Score] where VotingNum<>1 GROUP BY WorkNO ORDER BY NEWID();