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 they should be on different dates
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
Thanks,
reacha
Now i need to get only 2 pkgid's for each username they should be on different dates
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
Thanks,
reacha