Chuck, I didn't test, but the idea (for two) may help you:
Select max(ID), Location From yourTable Group By Location Ping 12/06/01 at 1:55pm --- "Tomasi, Chuck" <[EMAIL PROTECTED]> wrote: > 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 __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com
