Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the data like below,
customer | product | sales | Year |
A | shoe | 2000 | 2008 |
B | Mirror | 5000 | 2008 |
C | IronBox | 3000 | 2008 |
D | Light | 1000 | 2008 |
E | Lamp | 500 | 2009 |
E | Cable | 200 | 2010 |
E | Ironbox | 1000 | 2008 |
G | Char | 3500 | 2010 |
G | TV | 5000 | 2009 |
A | Paper | 6000 | 2010 |
In that data I need to find the maximum sales year of the customer. I need the output as below
The Required Output is
Customer Product Sales Year MaximumSaleYear
A shoe 2000 2008 2008
B Mirror 5000 2008 2008
C IronBox 3000 2008 2008
D Light 1000 2008 2008
E Lamp 500 2009 2008
E Cable 200 2012 2008
E IronBox 1000 2008 2008
G Char 3500 2010 2009
G TV 5000 2009 2009
A Paper 6000 2010 2010
I need the required outptut in straight table or in backend script..
Thanks in Advance..