1 2 3 4
--!syntax_pg select x,rank() over w,dense_rank() over w from (values (1),(2),(2),(3)) as a(x) window w as ()