Question

hql 子查询报错在sql中是可以执行的，只需要把类名改成表名。在线等

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ( near line 1, column 22 [select count(*) from (select ip, count(*) as cou from com.dbsours.score.pojos.LoginLog where login_time >= '2013-05-30' and login_time <= '2013-08-31' and 1=1 and login_status=1 GROUP BY ip ) as d WHERE d.cou>1]

Answer 1

hql 不支持子查询
用SqlQuery直接直接执行sql语句吧。