Re[2]: query question for sql experts

Ooooh I see your problem now. I will have a think about it and see if I can come up with something. Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: Re: query question for sql experts Author: <lesliet@writeme.com> at WCA-INET Date: 21/1/98 9:25 AM Thanks, David. Sorry, I gave a bad example. Let me try another example: TableA contains: EmpID GroupID CrDate 22 4 1/20/98 20 3 1/19/98 25 4 1/18/98 25 6 1/11/98 20 5 1/16/98 22 3 1/15/98 ... ... ... Expected query output: (Group by EmpID and order by lastest crdate first within each EmpID) EmpID GroupID CrDate 22 4 1/20/98 <- latest in crdate for a emp 22 3 1/15/98 20 3 1/19/98 <- second latest 20 5 1/16/98 25 4 1/18/98 <- 3rd latest 25 6 1/11/98 12 1/17/98 <- 4th latest 12 1/14/98 30 1/14/98 <- 5th latest 30 1/13/98 30 1/12/98 leslie } } } 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 } =-=-=-=-=-=-=-=-=-=-= } } } }