举例如下：
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 --排序
SQL SERVER数据库内，需要序列号进行排序时，排序方法
原文：https://www.cnblogs.com/since-1995/p/10797193.html