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));