I've got table to track my backup tapes. Each time a tape is used, I log a few things about it. I would like to construct a select statement to show me the last entry for tape has been.
desc tape; Name Type ============================= ID number Location number Updated date Input data may look something like: 1 12 10-Oct-01 2 14 10-Oct-01 1 12 12-Oct-01 4 10 12-Oct-01 2 14 14-Oct-01 In this case, I would only like the tree latest entries: 1 12 12-Oct-01 4 10 12-Oct-01 2 14 14-Oct-01 --Chuck
