SQL command to find the last record on an audit table Crystal report Oracle 10g
I am writing a SQL command report on an Oracle 10g database. The table tracks audits of changes to material's management inventory item records. The table has almost two million records. I would like your input on how to write an efficient query to find the last record updated for an item.