SQL SERVER数据库内，需要序列号进行排序时，排序方法

举例如下：

SELECT ROW_NUMBER()OVER(ORDER BY (SELECT 0)) AS ROWNUM,* FROM YXHIS2018..TBMZGHMX201801 --不排序
SELECT ROW_NUMBER()OVER(ORDER BY DCSNY DESC) AS ROWNUM,* FROM YXHIS2018..TBMZGHMX201801 --排序

原文：https://www.cnblogs.com/since-1995/p/10797193.html