sql server group by 嵌套 group by 问题

Question

select cuid from (select cuid,eid from test_sale group by cuid,eid ) group by cuid having count(eid)>=2 查询提示 “关键字 group 附近语法错误” 

Answer 1

group by 前面要加个别名，
select cuid from (select cuid,eid from test_sale group by cuid,eid ) as t1 group by cuid having count(eid)>=2

或者此查询也可以直接改为如下
select cuid from test_sale group by cuid having count(eid) >= 2