Generating list of numbers in Teradata Sql Asst

Question

I want to generate a list like -3, -4, -5, -6, -7 in Teradata Sql asst. Is there any direct way to do it. Sample attached here.enter image description here

Answer 1

In Teradata, there isn't a built-in function for generating a sequence of numbers. However, you can achieve this by using a recursive cte as follows:

WITH RECURSIVE nums AS
(
  SELECT -7 AS n FROM DBC.DBCInfoV WHERE InfoKey='Version' -- or from any table you already have
  UNION ALL
  SELECT n + 1 FROM nums WHERE n < -3
)
SELECT * 
FROM nums
ORDER BY n DESC