Solutionunvalidated
select rank() over (partition by order by ) as rn,* — This is a simple workaround for it. Outcome: as rn,* from ;.
e44af439-b88e-44b4-ba0a-13d1a04fa90b
select rank() over (partition by order by ) as rn,* — This is a simple workaround for it. Outcome: as rn,* from ;.