110,566
社区成员
发帖
与我相关
我的任务
分享
IF @total_count <> 0
SELECT top n --数字,自己设定,也可以是百分比
Id, Content, VoteNum, (100 * VoteNum + @total_count / 2) / @total_count AS per FROM [voteItem]
WHERE VoteId = @VoteId
order by Id desc(asc)
ELSE
SELECT top n --数字,自己设定,也可以是百分比
Id, Content, VoteNum, 0 AS per FROM [voteItem]
WHERE VoteId = @VoteId
order by Id desc(asc) --降序(升序)