On 2012.02.25 12:19 PM, Svein Erling Tysvær wrote: > > Not sure if it is any better when you only need two fields, but you > could, of course, use a CTE: > > WITH TMP_INVOICE(ID_INVOICE, AMOUNT_LAST_INVOICE, > CURRENCY_LAST_INVOICE) AS > (SELECT I.ID_INVOICE, I.AMOUNT, I.CURRENCY > FROM INVOICE I > LEFT JOIN INVOCE I2 ON I.ID_INVOICE = I2.ID_INVOICE > AND I.SomeUniqueField < I2.SomeUniqueField ... > WHERE I2.ID_INVOICE IS NULL) > If I understand correct the request, this is correct only if records are in chronologically order. There is possible to have records with row id smaler but date field value greater (the invoice arrive later into the office), in that case should compare date's fields and not rowid.
Hth, Paul MERCEA E-mail: [email protected] ___________________________________________ [Non-text portions of this message have been removed]
