MySQL ROW

SELECT ROW_NUMBER ( ) OVER ( PARTITION BY a.inspection_x ORDER BY a.id_x DESC ) AS rowNum, a.inspection_x, a.id_x FROM t_product_ins_x a WHERE a.STATUS = 0; *******语法格式：ROW_NUMBER ( ) OVER ( PARTITION BY 分组列 ORDER BY 排序列 DESC )