select_win_ntile.sql 150 B

12345678
  1. --!syntax_pg
  2. select
  3. r,x,
  4. ntile(3) over w
  5. from (select * from (values (1,3),(2,null),(3,4),(4,5)) as a(r,x)) as z
  6. window w as (order by r)
  7. order by r