Re: query question for sql experts

Leslie The result set is not doing a group by, it looks more like an order by. The SQL to produce your specified result set is: select empid, groupid, crdate from tablea order by empid asc, crdate desc Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: query question for sql experts Author: <lesliet@u.washington.edu (L. Tseng)> at WCA-INET Date: 21/1/98 2:42 AM 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 =-=-=-=-=-=-=-=-=-=-=