1、语法ROW_NUMBER() OVER(PARTITION BY COLUMN ORDER BY COLUMN)
SELECT * from (
SELECT
ROW_NUMBER() OVER(PARTITION BY BilLNO ORDER BY BilLNO) AS 序号,
*
FROM
MarkBalancrMaster)a
1、语法ROW_NUMBER() OVER(PARTITION BY COLUMN ORDER BY COLUMN)
SELECT * from (
SELECT
ROW_NUMBER() OVER(PARTITION BY BilLNO ORDER BY BilLNO) AS 序号,
*
FROM
MarkBalancrMaster)a