如下的sql，row_number最后会按照什么顺序生成排序的值？有规律吗？
会根据unnest([p1.m,p1.n,p1.f])里面，p1.m–>1,p1.n–>2,p1.f–>3这个字段的顺序来吗？感谢
select p1.a,
p1.b,
row_number() over (partition by p1.a) as c,
p2.unnest as d
from cms as p1,
unnest([p1.m,p1.n,p1.f]);
如下的sql，row_number最后会按照什么顺序生成排序的值？有规律吗？
会根据unnest([p1.m,p1.n,p1.f])里面，p1.m–>1,p1.n–>2,p1.f–>3这个字段的顺序来吗？感谢
select p1.a,
p1.b,
row_number() over (partition by p1.a) as c,
p2.unnest as d
from cms as p1,
unnest([p1.m,p1.n,p1.f]);