摘要: row_number函数 select row_number() OVER (PARTITION BY partColumns ORDER BY orderColumns),otherColumns from xx; partColumns-根据这些列分组,orderColumns-根据这些列排序, 阅读全文
posted @ 2019-01-09 17:06 扶不起的刘阿斗 阅读(137) 评论(0) 推荐(0) 编辑