DetachedCriteria query = DetachedCriteria.forClass(MoviePlayItem.class);
query.setProjection(Projections.projectionList()
.add(Projections.alias(Projections.groupProperty("movie"),"movie"))
.add(Projections.alias(Projections.rowCount(), "rowcount")));
//query.add(Restrictions.gt("rowcount", new Integer(0)));这样写有错误
query.addOrder(Order.desc("rowcount"));请问要求rowcount>0该怎么写? 类似于sql语句中的having
query.setProjection(Projections.projectionList()
.add(Projections.alias(Projections.groupProperty("movie"),"movie"))
.add(Projections.alias(Projections.rowCount(), "rowcount")));
//query.add(Restrictions.gt("rowcount", new Integer(0)));这样写有错误
query.addOrder(Order.desc("rowcount"));请问要求rowcount>0该怎么写? 类似于sql语句中的having
解决方案 »
- myeclipse for linux
- 关于spring 定时器的 时间问题
- ejb3新手
- hibernate问题
- JavaScript循环里面取出一个struts的list标签
- spring jdbc的错 ,帮忙看看什么问题啊?
- JBoss配置Mysql数据源,测试时一直报错:MySqlDS not bound(没有绑定!)
- jboss4.04问题:在控制台的左边applet显示不出
- 请问用java如何实现分享内容到facebook,请赐教!!
- 如何在WINXP更改tomcat中默认的JSP网页发布目录?还有如何配置SERVELET目录?
- soap,mime格式的附件
- 请问 poi 如何强制按String型读取数据
group by mpi.movie having count(*)>0 order by count(*) desc
效率也高
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1700,楼主不妨下载测试一下
group by mpi.movie having count(*)>0 order by count(*) desc").这样就可以了。