Re: query question for sql experts

This is a solution for you: select a.empid,a.groupid,a.crdate from aaa a, aaa b where a.empid = b.empid group by a.empid,a.groupid,a.crdate order by max(b.crdate) desc,a.crdate desc Phil Tsao phil@technologist.com L. Tseng wrote: > Hi, SQL experts, > > Your help on the following qestion will be much appreciated. > For example: > > TableA contains: > > EmpID GroupID CrDate > 22 4 1/20/98 > 24 3 1/19/98 > 25 4 1/18/98 > 25 6 1/17/98 > 24 5 1/16/98 > 22 3 1/15/98 > > how do I get a query output like the following with pure SQL code: > (Group by EmpID and order by the lastest crdate first within each EmpID) > > EmpID GroupID CrDate > 22 4 1/20/98 > 22 3 1/15/98 > 24 3 1/19/98 > 24 5 1/16/98 > 25 4 1/18/98 > 25 6 1/17/98 > -- > =-=-=-=-=-=-=-=-=-=-= > Leslie Tseng > lesliet@writeme.com > =-=-=-=-=-=-=-=-=-=-= -- Phil Tsao e-mail: philt@technologist.com http://www.expage.com/page/phil