What is your object model?
2011/4/16 Waqar Sadiq <[email protected]>: > I have a the following table with the data > > > TxnId StoreId ReceiptId RegisterId > Date LineItem Amount ..... > 123 345 678 399 > 4/16/2011 1 200 > 123 345 678 399 > 4/16/2011 2 150 > 123 345 678 399 > 4/16/2011 3 90 > 124 345 679 399 > 4/16/2011 1 200 > 124 345 679 399 > 4/16/2011 2 200 > 125 345 680 399 > 4/16/2011 1 200 > 125 345 680 399 > 4/16/2011 2 200 > 125 345 680 399 > 4/16/2011 3 200 > > In thism TxnId, Storeid, ReceiptId, RegisterId and Date fields form > the properties that I could be searching for but I do not always have > the all the fields all the time. Let us I have only the Date > available in a particular case. If I query where Date = 4/16/2011, I > will get 9 rows. I only want 3 rows, because I only want disticnt > rows based on the the first 5 fields. > > Can somebody help me with what my HQL needs to look like? > > Thanks in advance. > > Waqar > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
