select count(c) from (select b from TUserBankLogSum b group

来源：学生作业帮编辑：拍题作业网作业帮分类：综合作业时间：2024/06/11 16:38:41

select count(c) from (select b from TUserBankLogSum b group by b.tid) as c 这条hql是错的
按照这个意思应该怎么写

当然是错的
这个 select count(c) 里面的 c 应该是字段名称吧!
可是 select b from TUserBankLogSum b group by b.tid) as c 这最后的 c 是一个表名称啊?
再问： select count(b) from TUserBankLogSum as b 这条语句就是对的
再答： select count(b) from TUserBankLogSum as b 对这个是对的！可是 select count(c) from (select b from TUserBankLogSum b group by b.tid) as c 这个是错的！ count（c）里面的 c 和 as c 的 c 一个是代表字段，一个代表表名称
再问：怎样才能让他带表表名称呢
再答： select count(c) from (select b from TUserBankLogSum as b group by b.tid) as c 试试这个？
再问：这个和我提问的语句一样啊

select count(c) from (select b from TUserBankLogSum b group select a,b from 表名 group by a,b order by count(*) desc select A,B,C,D=(select count(*) from 表 where c=a.a and b=a.b SQL语句理解 select * from B where (select count(1) as num from A select count(*) from table1 select count(*) from table2 sele select count(*) from 怎么使用 select count(1) from emp select * from a union select * from b 能详细说下么 ms sql :select * from (select *from b) as xxx where 和 select select count(distinct b) from X_info where c=1;能放到一个CASE内么不 select * into b from a where 11 select count(*) from v$process a,v$session b where a.addr =