--oracel查询 去重复当前第一个
SELECT ROW_NUMBER() OVER(PARTITION BY tid,bank_id,mid ORDER BY DateReq DESC) LEV,table.* FROM table where and dateComE< TO_DATE('2013-01-24 23:59:59','yyyy-mm-dd hh24:mi:ss') )
WHERE LEV = 1
--oracel查询 去重复当前第一个
SELECT ROW_NUMBER() OVER(PARTITION BY tid,bank_id,mid ORDER BY DateReq DESC) LEV,table.* FROM table where and dateComE< TO_DATE('2013-01-24 23:59:59','yyyy-mm-dd hh24:mi:ss') )
WHERE LEV = 1