win_func_ntile.sql 138 B

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