declare @RtID int - -变量,保存回帖数最多的一个发帖人的ID
select top 1 @RtID = RtID ,count(RtID) from bbsReply 执行以上代码时就报错
错误是因为检索的数据列没有全部赋值给变量
1、可以去掉count(RtID)来解决
select top 1 @RtID = RtID from bbsReply
2、可以多加一个变量保存count(RtID)
declare @RtID int, @cRtID int
select top 1 @RtID = RtID , @cRtID = count(RtID) from bbsReply group by RtID
3、如果你想保存RtID并检索数据,就只能分两步走了
select top 1 @RtID = RtID from bbsReply
select top 1 RtID , count(RtID) from bbsReply group by RtID
1、可以去掉count(RtID)来解决
select top 1 @RtID = RtID from bbsReply
2、可以多加一个变量保存count(RtID)
declare @RtID int, @cRtID int
select top 1 @RtID = RtID , @cRtID = count(RtID) from bbsReply group by RtID
3、如果你想保存RtID并检索数据,就只能分两步走了
select top 1 @RtID = RtID from bbsReply
select top 1 RtID , count(RtID) from bbsReply group by RtID
温馨提示:答案为网友推荐,仅供参考
第1个回答 2015-07-08
select top 1 @RtID = RtID from bbsReply order by count(RtID) desc