Mysql实现Oracle中row_number ( ) over ( partition BY ORDER BY DESC )
Mysql实现Oracle中row_number ( ) over ( partition BY 字段1 ORDER BY 字段2 DESC )
例表:
案例1,row_number ( ) over (ORDER BY 字段2 DESC )
Oracle
Mysql
SELECT
b.*,
row_number ( ) over ( ORDER BY PRICE DESC ) AS rk
...
原创
2021-05-13 15:44:53 ·
1157 阅读 ·
0 评论