No. Date value
600000 1997/12/31 81640332000.000
600000 1998/12/31 87338217000.000
600000 1999/01/01 84926165775.750
600000 1999/06/30 87203199000.000
600000 1999/12/31 103209678011.880
600000 2000/06/30 113398097797.360
600000 2000/12/31 130722431719.440
600001 2002/09/30 9602807107.340 600001 2002/12/31 9817549165.150
600001 2003/09/30 13573975441.840
600001 2003/12/31 16587217772.990
600001 2004/01/01 16587217772.990
600001 2004/12/31 20070630250.400
600002 2003/09/30 6881521318.800
600002 2003/12/31 7214543000.000
600002 2004/03/31 8135641400.910
600002 2004/09/30 8751548446.830
600002 2005/01/01 9979756000.000
600002 2005/03/31 10465513352.670
如何找出每个编号每一年的最大日期啊?结果如下:
No. Date value
600000 1997/12/31 81640332000.000
600000 1998/12/31 87338217000.000
600000 1999/12/31 103209678011.880
600000 2000/12/31 130722431719.440
600001 2002/12/31 9817549165.150
600001 2003/12/31 16587217772.990
600001 2004/12/31 20070630250.400
600002 2003/12/31 7214543000.000
600002 2004/09/30 8751548446.830
600002 2005/03/31 10465513352.670
感激不尽!!!!!