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.
