排序去重1 https://www.cnblogs.com/alsf/p/6344197.html
排序去重2http://blog.csdn.net/ywl570717586/article/details/51395092
排序去重1 https://www.cnblogs.com/alsf/p/6344197.html
排序去重2http://blog.csdn.net/ywl570717586/article/details/51395092
ROW_NUMBER() OVER()函数用法;(分组，排序），partition by
原文：https://www.cnblogs.com/xyao1/p/8205381.html