query question for sql experts

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_at_writeme.com


=-=-=-=-=-=-=-=-=-=-=