hibernate distinct

想从DxfsCheckitem中查找出满足check_item不重复的记录

public List getDxfsCheckitemList() {


Session session = null;

String strSql= "from DxfsCheckitem y where (y.check_item,y.check_id)in(select x.check_item,max(x.check_id)from DxfsCheckitem x group by x.check_item)";
session = this.getHibernateTemplate().getSessionFactory().openSession();
Query query = session.createQuery(strSql.toString());

// 获得记录集总数
List list = query.list();

return list;

}

from http://blog.csdn.net/zrchao/article/details/4419107