Thanks for the suggestion,
I've tried to edit the query and added an order by in the OVER statement
but i'm still obtaining two results, but now of course those results are
sequential, the edited beginning of the query is:
SELECT *
FROM (
SELECT _id,
ROW_NUMBE
Davide Jensen writes:
> I'm encountering some problems in understanding the behavior of a query
> that uses an IN operator, the query i'm executing is the following:
> SELECT * FROM (
> SELECT _id,
> ROW_NUMBER() OVER () AS _rownumber
I think your problem is
Hi everyone,
I'm encountering some problems in understanding the behavior of a query
that uses an IN operator, the query i'm executing is the following:
SELECT * FROM (
SELECT _id,
ROW_NUMBER() OVER () AS _rownumber
FROM (
