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 )
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 )