Table of Contents
Result set with temporary sequence
Sometimes you would like to have a result set with something like a rownum. You can do this at least in the following two ways:
a) with a TEMPORARY MEMORY table:
CREATE TEMPORARY TABLE mem (
seq INT NOT NULL …
