sql-server - “ORDER BY (SELECT NULL)”是什么意思？

以下SQL来自Itzik Ben-Gan，用于生成数字表。 order by (select null)部分是什么意思？谢谢。

DECLARE @number_of_numbers INT;
SELECT @number_of_numbers = 100000;

WITH    a AS ( SELECT   1 AS i
               UNION ALL
               SELECT   1
             ),
        b AS ( SELECT   1 AS i
               FROM     a AS x ,
                        a AS y
             ),
        c AS ( SELECT   1 AS i
               FROM     b AS x ,
                        b AS y
             ),
        d AS ( SELECT   1 AS i
               FROM     c AS x ,
                        c AS y
             ),
        e AS ( SELECT   1 AS i
               FROM     d AS x ,
                        d AS y
             ),
        f AS ( SELECT   1 AS i
               FROM     e AS x ,
                        e AS y
             ),
        numbers
          AS ( SELECT TOP ( @number_of_numbers )
                        ROW_NUMBER() OVER ( ORDER BY ( SELECT   NULL
                                                     ) ) AS number
               FROM     f
             )
    SELECT  *
    FROM    numbers;

谢谢!

最佳答案

ROW_NUMBER在语法上需要ORDER BY子句。没有一个就不能使用它。 SELECT NULL是一种在不执行任何特定命令的情况下关闭错误的黑客。在这种情况下，我们不需要执行任何命令，因此最快的选择是使用SELECT NULL。

优化器可以解决这个问题，因此它没有运行时开销(通过查看执行计划可以轻松地验证此声明)。

关于sql-server - “ORDER BY (SELECT NULL)”是什么意思？，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/10066819/