如何在SQL中生成数字列表，因为它是一个理解列表? [英] How to generate a list of number in SQL as it was a list of comprehension?

问题描述

就我而言，在任何地方(sybase)使用sql.

In my case, using sql anywhere (sybase).

类似于haskell的东西. [1..100].

Something similar to haskell. [1..100].

我不知道如何生成1到100的随机简单列表.

I don't know how to generate a random simple list of 1 up to 100.

我只能这样做:

select 1
union 
select 2
union
select 3

Google没有提供任何示例，我怀疑此功能不存在.

Google did not provide any sample, I suspect this feature does not exist.

推荐答案

SQL Anywhere包含一个sa_rowgenerator存储过程，可用于此目的.例如:

SQL Anywhere contains an sa_rowgenerator stored procedure, which can be used for this purpose. For example:

select row_num from sa_rowgenerator( 1, 100 )

返回100行的结果集，范围从1到100(含1和100).该文档的链接(对于版本12.0.1)为

returns a result set of 100 rows from 1 to 100 inclusive. A link to the documentation (for version 12.0.1) is here.

免责声明::我在SQL Anywhere工程中为SAP/Sybase工作.

Disclaimer: I work for SAP/Sybase in the SQL Anywhere engineering.

这篇关于如何在SQL中生成数字列表，因为它是一个理解列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！