用什么子句去掉重复的记？ select Distinct(列名)from table
hibernate hql 语句去除重复数据 参考如下：功能：根据品牌查询param pageSize每页大小param currentLPagem当前第几页param productBlack产品品牌param productBlackItem产品分类param productSize产品尺码param keyWord搜索关键字returnpublic pageBean seachProductByBrank(int pageSize，int currentLPage，String product_Brank，String product_itemName){final String hql=\"from\"+OgrilProducts.class.getName()where product_Brank='\"+product_Brank' and product_itemName='\"+product_itemName' order by product_registerDate desc；final String hql=\"fromOgrilProducts.class.getName()as product where product.productItemName='product_itemName' and productBrank='product_Brank' and not exists(fromOgrilProducts.class.getName()where productItemName='product_itemName' and productBrank='product_Brank' and productItemNumber=product.productItemNumber and productId)；int allRow=this.getAllRowCount(hql)；总记录数int totalPage=pageBean.countTotalpage(pageSize，allRow)；总页数final int offset=pageBean.countOffset。
hql语句查询去掉某一字段重复的行保留一行 参考如下：功能：根据品牌查询param pageSize每页大小param currentLPagem当前第几页param productBlack产品品牌param productBlackItem产品分类param productSize产品尺码param keyWord搜索关键字returnpublic pageBean seachProductByBrank(int pageSize，int currentLPage，String product_Brank，String product_itemName){final String hql=\"from\"+OgrilProducts.class.getName()where product_Brank='\"+product_Brank' and product_itemName='\"+product_itemName' order by product_registerDate desc；final String hql=\"fromOgrilProducts.class.getName()as product where product.productItemName='product_itemName' and productBrank='product_Brank' and not exists(fromOgrilProducts.class.getName()where productItemName='product_itemName' and productBrank='product_Brank' and productItemNumber=product.productItemNumber and productId)；int allRow=this.getAllRowCount(hql)；总记录数int totalPage=pageBean.countTotalpage(pageSize，allRow)；总页数final int offset=pageBean.countOffset(pageSize，。
