错误：聚合不应出现在 WHERE 子句中

[木易十三]

select top 9 * from T_Infobase_Hotel A where (Recommend*10000 +ID) <
(select min(Recommend*10000+ID) AS ColName from
(select top 9 (Recommend*10000+ID) AS ColName from T_Infobase_Hotel B order by (Recommend*10000+ID) desc) tbltmp) order by (Recommend*10000+ID) desc

以上SQL要实现的是分页查询，按Recommend先 id后的顺序排序，运行时提示：聚合不应出现在 WHERE 子句中，除非该聚合位于 HAVING 子句或选择列表所包含的子查询中，并且要对其进行聚合的列是外部引用。

[dearbinge]

select top 9 * from T_Infobase_Hotel A where (Recommend*10000 +ID) <
 (select min(ColName) from 
 (select top 9 (Recommend*10000+ID) AS ColName from T_Infobase_Hotel B order by (Recommend*10000+ID) desc) tbltmp) order by (Recommend*10000+ID) desc

[-狙击手-]

select top 9 *
from T_Infobase_Hotel A
where
(Recommend*10000 +ID) <
(select top 1 (Recommend*10000+ID) AS ColName
from (select top 9 (Recommend*10000+ID) AS ColName
from T_Infobase_Hotel B order by (Recommend*10000+ID) desc
) tbltmp order by (Recommend*10000+ID))
order by (Recommend*10000+ID) desc

[GoAwayZ]

select top 9 * from T_Infobase_Hotel A  
where  
  (Recommend*10000 +ID) <  
(select top 1 (Recommend*10000+ID) AS ColName  
 from (select top 9 (Recommend*10000+ID) AS ColName  
  from T_Infobase_Hotel B order by (Recommend*10000+ID) desc
  ) tbltmp order by (Recommend*10000+ID))
 order by (Recommend*10000+ID) desc

[木易十三]

谢谢二楼，三楼的写法不报错了，但搜索结果不对