ROW_NUMBER() OVER函数的基本用法

语法：ROW_NUMBER() OVER(PARTITION BY COLUMN ORDER BY COLUMN)

http://jingyan.baidu.com/article/9989c74604a644f648ecfef3.html