oracle去重显示出其它字段,oracle去重统计

按oracle排序

row_number(over ) partitionbytwf.fkidorderbytwf.create date desc ) as CODE_ID

twf.fkid http://www.Sina.com/: twf.create date http://www.Sina.com /