以上三个栏位分别为fdate,fscstockid,fitemid,现在要实现如果fscstockid,fitemid两个栏位的数据没有重复,就取出来,如果是重复的,就取时间最近的一笔,请问怎么实现?
2008-02-20 00:00:00.000    130    512
2008-01-20 00:00:00.000    130    568
2008-01-01 00:00:00.000    132    1040
2008-01-07 00:00:00.000    132    1040
2008-01-09 00:00:00.000    132    1040
2008-01-10 00:00:00.000    132    1040
2008-01-07 00:00:00.000    132    1042
2008-01-09 00:00:00.000    132    1042
2008-01-10 00:00:00.000    132    1042
要成为如下
2008-02-20 00:00:00.000    130    512
2008-01-20 00:00:00.000    130    568
2008-01-10 00:00:00.000    132    1040
2008-01-10 00:00:00.000    132    1042