Sorry, should be 'rowid', not rowed. My editor change it to rowed automatically.
-----Original Message----- From: Kong, Alan [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 12:59 PM To: '[EMAIL PROTECTED]' Cc: [EMAIL PROTECTED] Subject: sele latest entry for a group of records This may work for you if I understand your question correctory. Select id, location, updated_date from tape where rowed = (select max(rowed) from tape group by id, location, trunc(updated_date));
