In my report i have group by username,ScannedDate,AccountNumber.
So i need to get the only one account number per user that is oldest account associated with that user
for EX:
Username ScannedDate AccountNumber
--------- ----------- -------------
tom 11/24/2010 1000
George 11/6/2008 2000
4/15/2009 2001
5/28/2009 2002
peter 11/10/2010 3000
11/15/2010 3010
Output should be:
------------------
tom 11/24/2010 1000
George 11/6/2008 2000
peter 11/10/2010 3000
Please help me out!!
Thanks,
reacha
So i need to get the only one account number per user that is oldest account associated with that user
for EX:
Username ScannedDate AccountNumber
--------- ----------- -------------
tom 11/24/2010 1000
George 11/6/2008 2000
4/15/2009 2001
5/28/2009 2002
peter 11/10/2010 3000
11/15/2010 3010
Output should be:
------------------
tom 11/24/2010 1000
George 11/6/2008 2000
peter 11/10/2010 3000
Please help me out!!
Thanks,
reacha