Hibernate 多字段distinct查询

来源:互联网 发布:博拉网络 中金在线 编辑:程序博客网 时间:2024/05/17 22:35

SQL语句

select distinct uspscity, state from citycomplete where USPSCITY = 'HOUSTON'

Java代码

ProjectionList projList = Projections.projectionList();projList.add(Projections.property("id.state"));projList.add(Projections.property("id.uspsCity"));criteria.setProjection(Projections.distinct(projList));
0 0