Oracle和SQL server的关键字是over partition by mysql的无关键字row_number() over (partition by col1 order by col2),表示根据col1分组,在分组内部根据col2排序 1.原始表 2.