Generating a Series I

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Carlo Romagnano SSC-Insane Points: 22771 More actions · Answer 1

SSC-Insane

Points: 22771

June 13, 2025 at 6:21 am

Thanks!

Hallelujah!

Ken McKelvey SSCoach Points: 18927 More actions · Answer 2

The question leads to another question:

As the result of GENERATE_SERIES() is a set, can it really be ordered without an ORDER BY clause?

Steve Jones - SSC Editor SSC Guru Points: 738337 More actions · Answer 3

It's returned in an order, but technically that can be changed:

SELECT value
FROM GENERATE_SERIES(1, 10) ORDER BY value desc;