是否有一个SQL函数可以生成给定范围的序列号？(Is there an SQL function which generates a given range of sequential numbers

是否有一个SQL函数可以生成给定范围的序列号？(Is there an SQL function which generates a given range of sequential numbers?)

我需要生成一个具有给定范围的连续整数数组，以便在以下位置使用它：

SELECT tbl.pk_id FROM tbl WHERE tbl.pk_id NOT IN (sequential array);

I need to generate an array of sequential integers with a given range in order to use it in:

SELECT tbl.pk_id FROM tbl WHERE tbl.pk_id NOT IN (sequential array);

最满意答案

因为你说你已经有了一个数字表，我会建议：

SELECT element FROM series WHERE element NOT IN (SELECT pk_id FROM tbl)

可能比您尝试过的查询更有效。

Because you say you've already got a number table, I would suggest this:

SELECT element FROM series WHERE element NOT IN (SELECT pk_id FROM tbl)

Might possibly be more efficient than the query you've tried.