Question

sql server group by 嵌套 group by 问题

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

Answer 2

你这个没有打开哪个表啊 select cuid,eid from test_sale group by cuid,eid 这只是个条件 应该在from后面加上你的表名啊

Answer 3

select cuid from (select cuid,eid from test_sale group by cuid,eid ) as tb group by cuid having count(eid)>=2