[RBG7-L] - Re: Date Function

[Lawrence Lustig]

> bro * fro d_invoice_status where inbox_state = 2 and
> (lmin(state_changed_dt)) 

BROWSE & FROM D_Invoice_Status D1 WHERE Inbox_State = 2 AND +
  NOT EXISTS (SELECT * FROM D_Invoice_Status +
    WHERE State_Changed_Dt < D1.State_Changed_Dt)

will show the single row with the lowest State_Changed_Dt and

BROWSE & FROM D_Invoice_Status D1 WHERE Inbox_State = 2 AND +
  NOT EXISTS (SELECT * FROM D_Invoice_Status +
    WHERE PrimaryKeyCol = PrimaryKeyCol AND +
          State_Changed_Dt < D1.State_Changed_Dt)

will show the lowest-dated row for each PrimaryKeyCol value.
--
Larry