SQL ROW_NUMBER

CREATE TABLE RowNumberTable
(
	ID UNIQUEIDENTIFIER,
	Version INT,
	DataStage VARCHAR(100)
)

SELECT * FROM RowNumberTable

INSERT INTO RowNumberTable(ID,[Version],DataStage)VALUES(NEWID(),1,'DS_02');
INSERT INTO RowNumberTable(ID,[Version],DataStage)VALUES(NEWID(),2,'DS_02');
INSERT INTO RowNumberTable(ID,[Version],DataStage)VALUES(NEWID(),3,'DS_02');
INSERT INTO RowNumberTable(ID,[Version],DataStage)VALUES(NEWID(),4,'DS_01');
INSERT INTO RowNumberTable(ID,[Version],DataStage)VALUES(NEWID(),5,'DS_01');
INSERT INTO RowNumberTable(ID,[Version],DataStage)VALUES(NEWID(),6,'DS_01');
INSERT INTO RowNumberTable(ID,[Version],DataStage)VALUES(NEWID(),7,'DS_03');
INSERT INTO RowNumberTable(ID,[Version],DataStage)VALUES(NEWID(),8,'DS_03');
INSERT INTO RowNumberTable(ID,[Version],DataStage)VALUES(NEWID(),9,'DS_03');

--DELETE FROM RowNumberTable
--获取信息
SELECT * FROM RowNumberTable
--根据Version排序
SELECT *, ROW_NUMBER() OVER (ORDER BY [Version] ASC) AS num FROM RowNumberTable
--根据DataStage,Version排序
SELECT *, ROW_NUMBER() OVER (ORDER BY DataStage ASC,[Version] ASC) AS num FROM RowNumberTable
--根据DataStage,排序
SELECT *, ROW_NUMBER() OVER (PARTITION BY DataStage ORDER BY [Version] ASC) AS num FROM RowNumberTable

--根据Version排序
SELECT *, ROW_NUMBER() OVER (ORDER BY [Version] ASC) AS num FROM RowNumberTable

--根据DataStage,Version排序
SELECT *, ROW_NUMBER() OVER (ORDER BY DataStage ASC,[Version] ASC) AS num FROM RowNumberTable

--根据DataStage,排序
SELECT *, ROW_NUMBER() OVER (PARTITION BY DataStage ORDER BY [Version] ASC) AS num FROM RowNumberTable