I have a report in which first i have grouped by supervisorname,username,auditdate,pkgid

Now i need to get only 2 pkgid's for each username that can be on same date or different date

For Ex:

Supervisor  Username   Auditstamp    pkgid
--------------  -------------  ---------------   -------
TOM          Peter           11/30/2010   10000
                                    11/31/2010   10001
                                    12/05/2010   10005

Adam         james         12/01/2010   10010
                                                          10012
                                     12/05/2010   10014

Output should be
----------------

Supervisor  Username   Auditstamp    pkgid
--------------  -------------  ---------------   --------
TOM          Peter           11/30/2010   10000
                                    11/31/2010   10001

Adam         james         12/01/2010   10010
                                    12/05/2010   10014

 

 

I need to get random number for each user whenever i run the report


Thanks,
reacha