Question

select *from (select id,count(branch_id) as cnt from commuit group by branch_id) as t1 where t1.cn

老是提示SQL错误. 请大神们看下,语句哪里有问题

Answer 1

什么数据库？ 试试这样(把虚拟表的as去掉）？

select * from
(select id,count(branch_id) as cnt from commuit
group by branch_id
) t1 where t1.cn ？？？

后面还有呢？

Answer 2

select *from (select id,count(branch_id) as cnt from commuit group by branch_id) as t1 where t1.cn
中where 后面需要加查询条件的，如where t1.cn=2这样

Answer 3

select *from (select id,count(branch_id) as cnt from commuit group by id) as t1 where t1.cn即可