From daemon Mon Jan 15 05:08:25 1996 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM) id AA01030; Mon, 15 Jan 1996 05:08:22 -0500 Message-Id: <9601151008.AA01030@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 7655; Mon, 15 Jan 96 04:53:52 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 6125; Mon, 15 Jan 1996 04:53:50 -0500 Date: Mon, 15 Jan 1996 15:25:35 +0000 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: "PGDST94-95 P.Rajesh" Subject: Re: SQL question X-To: "ORACLE database mailing list." To: Multiple recipients of list ORACLE-L In-Reply-To: <199601121355.TAA13236@sangam> Hi , select name,value1,value2,time from table a where time = (select max(time) from table b where a.name = b.name) This we have tested on Sybase 10.0 it works and you try it out. rajesh.p