Hi,

I'm trying to figure out how to do the HQL for select distinct.

I have an object called BOL that maps to table called Mbol

table structure
=================
rowid
BOLNum
OrderNum
SKU
ShipQuantity

Object
===========================
public class BOL {
private long rowID;
private String bolNumber;
private String orderNum;
private String sku;
private int shipQuan;

public String getOrderNum() {
return orderNum;
}

public int getShipQuan() {
return shipQuan;
}

public String getSku() {
return sku;
}

public void setOrderNum(String string) {
orderNum = string;
}

public void setShipQuan(int i) {
shipQuan = i;
}

public void setSku(String string) {
sku = string;
}

public String getBolNumber() {
return bolNumber;
}

public void setBolNumber(String string) {
bolNumber = string;
}

public long getRowID() {
return rowID;
}

public void setRowID(long i) {
rowID = i;
}

}
===========================================

I want to do a query

select distinct OrderNum from mbol where BOLNum = "XXXX"

Is there a way this can be done in HQL ?

Of course: