Re: Can an SQL common table expression be used for many different selects?

On Wed, Jul 29, 2020 at 3:32 AM Maria Lucia Stoppa <mlstoppa@xxxxxxxxx> wrote:

To me, it seems that DB2_NUMBER_ROWS shows the number of fetched rows, just
like ROW_COUNT, maybe due to the presence of offset and fetch first clauses.

Or, am I doing something wrong?

I don't think you are doing anything wrong. The documentation is on
the dry and formal side, but what I *think* it is saying is exactly
what you are seeing. I believe the "result table" mentioned in the
passage quoted by Birgitta refers to the actual rows retrieved by the
SQL engine, so if your statement includes a limit on the number of
rows (such as with FETCH FIRST), then that would limit the size of the
result table.

John Y.