摘要: --查询某字段不重复数据并取出最新的select * from (select m.proposalno,m.operatedate,m.underwriteflag ,row_number() over(partition by underwriteflag order by operatedat 阅读全文
posted @ 2018-08-02 11:22 wuyueping 阅读(111) 评论(0) 推荐(0) 编辑